Category: Power BI

Deep Dive on Power BI and SharePoint
Deep Dive on Power BI and SharePoint
Webinars

SharePoint and Power BI can work very well together. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session… READ MORE

Power BI: Changing Data Source from Excel to SQL
Power BI: Changing Data Source from Excel to SQL
Blog Posts

Migrating data sources at times can be tricky in Power BI. This article focuses on how to change the data source from an Excel table to a SQL table in minimum possible steps, considering the following scenarios: The name and structure of the data source tables are different in Excel and SQL. It includes a… READ MORE

Power BI – Scheduled Refresh for your Dataflow
Power BI – Scheduled Refresh for your Dataflow
Blog Posts

Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE

How to Capture SQL Queries Generated by Power BI
How to Capture SQL Queries Generated by Power BI
Blog Posts

Once upon a time, your old scary DBA walked into your office with a red-colored face and asked you furiously: “What the hell you’ve done with your Power BI report?! It killed all of our workloads!!!” You knew why he was angry, even before he started screaming at you. It’s because of “that” report which… READ MORE

Organize and Monitor the Power BI Scheduled Refreshes
Organize and Monitor the Power BI Scheduled Refreshes
Blog Posts

With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only limited parallel refreshing resources. So, you can only refresh one dataset at the same time… READ MORE