Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a sharepoint page which contains an excel file. I am trying to see if there is a way to just use the web page link to access the excel file in Power Bi Desktop.
So, I use dthe Web Data Source and pasted my sharepoint page URL. Instead of getting the excel content, I got the schema of the page instead of the excel content. Something like this:
Is there a way to import the excel content using the page URL?
Hi @kaka,
In your scenario, as the Excel file stored in the SharePoint site, you can use SharePoint Folder data source in desktop to get data from the Excel.
Then in Query Editor, you can filter to keep the specific Excel file and extract it's content. See: Combine binaries in Power BI Desktop.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |