Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm really confused on the way to connect Excel file data from Sharepoint to PBI Desktop
I'm following the below video and of course I got blocked right away.
https://www.youtube.com/watch?v=XuLnSYjmsJo
Here is what I try to achieve:
1. Connect My professional sharepoint to PBI Desktop
2. Find the excel file I am interested in and load the data/ import the data on PBI Desktop
3. Create a visualization
4. Get an update of the visualization every time the source file is updated.
I'm using Power BI desktop for Report Server, with a professional account.
When I do: get datat > Sharepoint Online Folder > I enter the "home page" URL of my sharepoint > Transform data.
At this point I am in the Power Query Editor. In the column Folder Path I need to filter the list to get the folder path I am interested in:
Text Filters > Contains > I enter the folder name I need to open to access the file I need to use.
Here is the result:
Did anyone have the same issue and was able to solve it?
Or anyone has suggestions?
Thanks,
Melanie
Hi @Anonymous ,
This is the related document, you can view this content:
Re: SharePoint: Request failed: The remote server ... - Page 2 - Microsoft Power BI Community
SharePoint: Request failed: The remote server retu... - Microsoft Power BI Community
DataSource.Error: SharePoint: Request failed: The ... - Microsoft Power BI Community
Solved: DataSource.Error: SharePoint: Request failed - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous,
Have you tried the Web connector? Use the full path of the Excel file through the end of the file name (delete characters after .xlsx).
Proud to be a Super User!
Hi @DataInsights ,
Yeah, I tried with Web connector delete characters after .xlsx but I does not work either.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |