Power BI tip: How to get data from an Excel file in SharePoint?
SharePoint is a platform of Microsoft 365 that is used for collaboration within an organization. It is a website that acts like a file database or content management system. Employees can easily store files and share them within the organization.
The problem may occur when you want to import an Excel file in SharePoint to Power BI. When you try to get data via the Excel workbook, you have to go to the file location. However, it may difficult to access Sharepoint locations sometimes.
There is another way that I usually use. You can get data via the web.
The input URL can be acquired if you can open the excel file.
From the Excel file, click on the File tab. Then, click Info and Copy path. After that, paste the copied path in the URL in Power BI.
You should see the .xlsx?web=1 in the link. Delete ?web=1 and click OK.
Done!!
If this article is helpful, please clap and follow me for more data science articles.
The articles that might you might interested in.
- Python in Power BI: https://medium.com/mlearning-ai/python-in-power-bi-66a80590ecc0
- Power BI Tip — How to custom sort categorical/text columns in a bar chart?: https://medium.com/@yannawut/power-bi-tip-how-to-custom-sort-categorical-text-columns-in-a-bar-chart-cadc232e35a0
