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 […]
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 […]
Power BI Connections: Live Connection
Of all the connection types, I’ve always gravitated towards this one. I imagine it is because I come from the database developer side of things. […]
Power BI Connections: Direct Query
Now that we’ve solidly gotten through the basics in terms of what connection types are in the opening blog, found here, and detailed out what […]
Power BI Connections: Import
Power BI’s default connection type is Import. In fact, if you have never dealt with a data source that handles multiple loading methods, you may […]
Power BI Connection Types
Get Data – Power BI Connection Types: An Introduction Hi, I’m Seth, I am very excited to be a contributing on PowerBI.tips. Mike has done […]
Get Your OData Here
For those of you who are following my tutorials, you are most likely to understand that each tutorial comes with it’s own data source. This […]
Loading Excel Files from Sharepoint
This is a quick tutorial on how to load Excel files from a SharePoint page. SharePoint is a nice landing place for your data because […]
Load Multiple Excel (xls or xlsx) Files
Previously we’ve done a tutorial on loading multiple text files within one query. This is nice, however we will also need to import multiple Excel […]
Loading Data From Folder
Let me setup a scenario for you. You get a data file from an automated system, it has the same number of columns but the […]