Tag: 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 – 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

Built-in Column Sort Order in Power BI
Built-in Column Sort Order in Power BI
Blog Posts

The sort by column feature of Power BI hides some potentially unwanted complexities. This blog post shows how you can avoid having to sort a column by another column while maintaining a custom sort order. The problem Here’s a typical example: you sort month names by month numbers. Let’s say you want to remove filters… 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

Single-letter day and month names in Power BI
Single-letter day and month names in Power BI
Blog Posts

Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one… READ MORE