Microsoft Power BI is a self-service Business Intelligence tool that lets you connect to multiple different data sources – Power BI offers 92 different data connectors to connect the data sources. With these connectors, you can connect to different data sources. Power BI offers two different Data Connectivity modes to connect the data sources – Import Read More
How to Setup BCC on a User’s Email on Google Workspace.
When I was recently working on a Google Workspace deployment project, customer asked me if its possible to watch users emails, So I did some research and testing to find if its really possible. Author – Goldy Arora – Google Workspace Certified Consultant So Can Google Workspace Admin Read My Email? Google allows Google Workspace Read More
How to Transpose a Table in Power BI
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