The transpose table operation in Power Query rotates your table 90 degrees, turning your rows into columns and your columns into rows. Imagine a table like the one in the following image, with three rows and four columns. Table with four columns named Column1 through Column4, with all columns set to the Text data type. Read More
Category: Power BI
How to Sort One Column by Another Column in Power BI
When you’re editing a report in Power BI Desktop, you can choose a column to define the sort order of another column by setting the Sort by column. Here’s a common example. You have a Month Name column, and when you add it to a visual, the months are being sorted alphabetically: April, August, December, February, Read More
How to Configure Incremental Refresh Datasets for Power BI Pro
Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data. For most datasets, this is one or more tables that contain transaction data that changes often and can grow exponentially, like a fact table in a relational or star database schema. By Read More
How To Download Exchange Rates In Power BI
I’m going to show you in this tutorial how you can download exchange rates into your Power BI data model. This is perfect if you need to bring in the latest exchange rates for some evaluation work or for financial reports where you have to deal with sales from a variety of different regions around the world. You Read More
How to Configure Microsoft Power BI Connector for Shopify
Power BI Connector is an application for Power BI Shopify integration. It allows you to easily export the key e-commerce data from your Shopify store to Microsoft Power BI for further visualization and analytics. With this application you can: stream key Shopify store data to Power BI and transfer raw data into an understandable format; Read More
How to Create a Dataflow in PowerBI Workspaces
A dataflow is a collection of tables that are created and managed in workspaces in the Power BI service. A table is a set of columns that are used to store data, much like a table within a database. You can add and edit tables in your dataflow, as well as manage data refresh schedules, directly from the workspace Read More