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
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
Hot to Move Dataflows Across Workspaces With the Power BI REST API
Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of refresh failures from different sources. Same as for your data sources, 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 Send an Email With Other From Address in Outlook
What to Know Select From in the header of an Outlook new message, reply, or forward. Choose Other Email Address. Select an address or type one in and select OK. This article explains how to send an email with any From address in Outlook for Office 365, Outlook 2019, 2016, 2013, and 2010. How to Send an Email With Read More