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.
Hi MikeGanem3,
Thanks for reaching out to the Microsoft fabric community forum. Thank you Heruy, for your valuable input regarding the issue.
After thoroughly reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:
To re add the Excel file in Power BI Desktop, open your Power BI Desktop report and navigate to Transform Data > Data Source Settings. Click Change Source and choose either SharePoint Folder or OneDrive for Business, depending on where your file is stored. Please enter the correct OneDrive URL, apply the changes, refresh the report, and then save and publish it again to Power BI Service. This will create a new semantic model referencing the OneDrive file.
Go to Power BI Service. Navigate to Settings > Manage Connections and Gateways. Your Connection Type should now show as "SharePoint" instead of "File." If prompted, enter your Microsoft credentials OAuth2 is recommended.
In Power BI Service, go to Datasets > Settings. Under Data source credentials, make sure credentials are correctly set. Enable Scheduled Refresh and test a refresh.
Kindly refer the below following links for better understanding:
Refresh a semantic model created from an Excel workbook - cloud - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Troubleshoot refresh scenarios - 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.