Our Tips

Publish a report in a Workspace

Publish to the Power BI Service

Here is my recommended procedure to publish a report created in Power BI Desktop to the Power BI Service. When you purchase Power BI PRO licenses for your Power BI users, you will be able to...



Read More
Open file locally to find the file path

Import a file from SharePoint, OneDrive or Teams

By importing a file as a web source, the Power BI report publishing process on the Power BI Service will be simplified. On the contrary, if the file is imported conventionally into Power BI...



Read More
Data Source Settings window in Power BI Desktop

Edit the Credentials linked to a Cloud or Web Data Source

There are times when you need to change a data source connection credentials in Power BI Desktop. Or that you entered a wrong username. Here is a step-by-step demonstration on how to delete...



Read More
OneDrive repository

Import a SharePoint Folder

On the Microsoft online documentation, you will find different options to Connect to a SharePoint Folder. Yet the troubleshooting scenarios do not suit the needs of many clients.   Here is...



Read More
Files Folder in Teams

Import a Teams Folder

Here is a tutorial on how to use a blank query with SharePoint.Contents( ) to import a Teams folder and combine its content in Power BI Desktop.   The following step-by-step demonstration...



Read More

Teaching Power BI with Success!

I love teaching Power BI. Every morning I meet new positive and motivated people. As the day unfolds, I see little light bulbs go off in the learners’ head, as the blocks of knowledge interlock. And...



Read More

Power BI on a Smaller Scale

Hope that you also had a great summer! I traveled to visit friends and family. One of my stops was at a dairy farm. Amazing how doing someone else’s job for one day can be so much fun: fixing a...



Read More