Power Query API Considerations
This article is the second part in a series on API calls. It will look at some best practices and considerations when using API calls in Power Query.
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 […]
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 […]