Data Sources
Make PBIDS Files
In October of 2019 Power BI released a new file type, PBIDS. The Power BI Desktop Source (PBIDS) file is a JSON object file that aids users connecting to data sources. In true PowerBI.Tips fashion […]
Year: 2019
Data Preparation Tips
Historical Stock Price Function in Power Query
This post will walk through how to pull daily stock price from Yahoo! Finance, then transform the data using a technique called a query branch. It will be completed all in the Power Query Editor. […]
Articles & Opinions
Power Query – Get Started!
As a user that builds Power BI reports, did you know the different technologies that come into play when you interact with the tool? This is one of the first questions I ask to new […]
Report Visualization Tips
Filled Donut Chart, Yumm..
We are starting today off with a fun chart. We will be making a filled donut chart. Typically, I don’t use donut charts but in this case I think we have a good reason, and […]
Data Sources
Power BI datasets: A Method to the Madness
As report authors we sometimes get caught up in how easy it is to create a report and provide value to the business. Each report is an opportunity to make a big contribution to the […]
Report Visualization Tips
Custom Sort Order Within a DAX Measure
This post will answer how to sort a measure that returns text values to a custom order, without affecting other columns. It will utilize the DAX functions of REPT() and UNICHAR(8203) – a Zero width […]
Report Visualization Tips
Grouping with Style
Grouping with Style The release of grouping visuals was an extremely welcomed feature. As one who builds lots of reports grouping elements together is essential to stay organized and to increase report building speed. Since […]
Sharing & Administration
Updating PBIX Files in SharePoint: Do’s & Don’ts
I recently encountered a really frustrating experience related to a set of reports seeming to not update after some data source changes. I’d done this change before, and had another co-worker take on the task […]
Report Visualization Tips
Dual Y-Axis Line Chart
Ever need two different scales on the Y-Axis of a line chart? If so, then this tutorial is for you. While creating a dual y-axis line chart is pretty common in excel, it is not […]
Sharing & Administration
Power BI Refresh Overview
There are different ways you can connect to a multitude of different data sources. I’ve written about the different connection types before and you can find those articles here if you are unfamiliar with what […]