Subscribe to EnjoySharePoint YouTube channel to get more free videos in SharePoint.
In this Power BI tutorial, we are going to explore how to Connect to a specific file from the SharePoint site in Power Bi.
Connect to a Specific file from SharePoint to Power BI
This is the scenario where I have some files in a SharePoint site inside a Shared Document’s document library. I just want Power Bi to pick the single file in order to process the data and form the beautiful reports.
Now as you are seeing below, I have opened the file inside SharePoint and click on the Open in the Power BI Desktop App. You will be prompted below message; you need to click Open Excel.
Once its opened click on the File menu and go to Info and select Copy Path to clipboard as shown below.
Now we need this copied path so save to Notepad and discard ?web=1 from the URL and copy it back.
https://enjoysharepointsky.sharepoint.com/sites/DemoSite/Shared%20Documents/InterestRates_3-31-2018.xlsx?web=1
So, now we need to open the Microsoft Power BI desktop tool and in order to get data from a folder we need to click here Get Data down and I choose the Web option and click the folder.
Paste the copied URL and hit OK.
It will open the selected file as shown below, here one thing you need to understand is that since I have already connected to SharePoint, that’s why I have not prompted the Access issue. If you are using the SharePoint URL for the first time, then do provide Credentials and connect to the site.
Now if you are OK with the existing contents you can hit Load otherwise select Edit and make changes into Query Editor.
Once we select Load it will load the data into Power BI, as shown below. Now we can provide some meaning full name to the Data like interest rates.
Finally, we will process this data to form a beautiful report by selecting fields and visuals like below.
You may like the following Power BI tutorials:
- How to combine multiple files from SharePoint folder in Power BI
- Power BI: How to Connect Most Recent File from a Folder
- Publish to Web Power BI Error: Contact Your Admin to Enable Embed Code Creation
- Integrate Power BI Reports in SharePoint Online
- How to Integrate Power BI with SharePoint Online
So in this tutorial, we have learned how to connect to a specific file from SharePoint to Power BI. I hope you found this tutorial to be very helpful.
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com