Forum Discussion
How to use Excel Sharepoint Streamlined Upload?
Hi pbi-admin ,
This error message usually occurs when Power BI is unable to determine the OneDrive location. You can try the following steps to resolve the issue:
- Check if the OneDrive account is connected to Power BI.
- Check if the OneDrive account has the necessary permissions to access the data.
- Check if the OneDrive account has been moved or renamed.
- Clear the browser cache and cookies and try again.
- Make sure your OneDrive or SharePoint Online library is configured to be available offline.
If this doesn't help, try connecting the excel file on sharepoint in power bi desktop and then publish it to the workspace.
Please refer to the following documents for more information.
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Publish from Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi pbi-admin ,
This error message usually occurs when Power BI is unable to determine the OneDrive location. You can try the following steps to resolve the issue:
- Check if the OneDrive account is connected to Power BI.
- Check if the OneDrive account has the necessary permissions to access the data.
- Check if the OneDrive account has been moved or renamed.
- Clear the browser cache and cookies and try again.
- Make sure your OneDrive or SharePoint Online library is configured to be available offline.
If this doesn't help, try connecting the excel file on sharepoint in power bi desktop and then publish it to the workspace.
Please refer to the following documents for more information.
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Publish from Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, I did not manage to get the initial solution to work but your last suggestion works, so I will go with that and configure a scheduled refresh of that data source.