Forum Discussion
Data Refresh Fails when Uploaded from Desktop to Service
Hi MikeGanem3,
Please consider implementing the insights shared by Heruy. If they prove useful, kindly accept the answer. If not, please provide further details. Thank you Heruy, for your valuable input and kind words. Also, please go through the below alternative workarounds that may resolve the issue:
In Power BI Service, go to the workspace with the dataset, then navigate to Settings > Datasets. Ensure all data source credentials are correct and up to date. Update any missing or incorrect credentials and try refreshing again.
Use the web URL for the OneDrive file instead of the local file path. This helps avoid local path issues. Open your Power BI Desktop report, go to Transform Data > Data Source Settings, click Change Source, and enter the web URL.
If you are utilizing a gateway, please ensure it is correctly configured and operational. Navigate to Manage Connections and Gateways in the Power BI Service to verify the gateway settings. Clearing the cache in Power BI Desktop can sometimes resolve data refresh issues. Go to File > Options and settings > Options > Data Load and select Clear cache. Recreating the report from scratch might also help identify issues with the original file.Kindly refer the below following link for better understanding:
Refresh a Power BI Desktop File (pbix file) from OneDrive or SharePoint Online - Power BI | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Thank you.
Thnaks for providing the details, but, that is how I created the report and published it. And the URL is correct for OneDrive
Hi MikeGanem3,
Please consider implementing the insights shared by Heruy. If they prove useful, kindly accept the answer. If not, please provide further details. Thank you Heruy, for your valuable input and kind words. Also, please go through the below alternative workarounds that may resolve the issue:
In Power BI Service, go to the workspace with the dataset, then navigate to Settings > Datasets. Ensure all data source credentials are correct and up to date. Update any missing or incorrect credentials and try refreshing again.
Use the web URL for the OneDrive file instead of the local file path. This helps avoid local path issues. Open your Power BI Desktop report, go to Transform Data > Data Source Settings, click Change Source, and enter the web URL.
If you are utilizing a gateway, please ensure it is correctly configured and operational. Navigate to Manage Connections and Gateways in the Power BI Service to verify the gateway settings. Clearing the cache in Power BI Desktop can sometimes resolve data refresh issues. Go to File > Options and settings > Options > Data Load and select Clear cache. Recreating the report from scratch might also help identify issues with the original file.
Kindly refer the below following link for better understanding:
Refresh a Power BI Desktop File (pbix file) from OneDrive or SharePoint Online - Power BI | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi MikeGanem3,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi MikeGanem3,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi MikeGanem3,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.