Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI all,
How to import data from excel file in sharepoint folder, i tried to paste the link of the folder but it gives me error
Hi @MostafaGamal ,
You may go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop, find the data source stored SharePoint, click "clear permissions" .
Then connect to the data using SharePoint folder connector again, use the URL below and use organizational account method. See more: Connecting to Files in SharePoint & OneDrive with Power BI / Power Query.
https://xxxxx.sharepoint.com/sites/<sitename>
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try this:
1. Use Web Connector.
2. 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!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |