Data Sources
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 it can be connected to the PowerBI.com service and thus […]
Data Sources
Data Sources
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 files. First, to understand the procedure of querying multiple excel […]
Data Sources
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 data changes for every new file. Being the data savvy […]
Data Sources
Folder of Files Loaded to Power BI Desktop
Ok, I’ve got to be honest the first two tutorials (Loading Excel Files, Loading CSV Files) were only there to get things kicked off. Now we are getting to some of the good stuff. When […]
Data Sources
Import CSV file to Power BI
This post is going to be similar to my previous post about Getting Data. I figure we better cover some of the basics before going crazy with deeper topics. Materials for this tutorial: CSV file […]
Data Sources
Import an Excel file into PowerBI
We are going to kick this blog off with a simple example of how to load data from excel into Power BI Desktop. Note: I’m a firm believer of always understanding your data. If you […]