Forum Discussion

MikeGanem3's avatar
MikeGanem3
Helper I
1 year ago
Solved

Data Refresh Fails when Uploaded from Desktop to Service

I created a Desktop report and used an Excel file on OneDrive, the refresh works fine. I uploaded it to Service (online) which created a Semantic file along with the report.  The report comes up fin...
General Comment
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    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.

Heruy's avatar
Heruy
Frequent Visitor
1 year ago

Hi MikeGanem3 & v-kpoloju-msft ,
I've managed to solve the issue v-kpoloju-msft  thank you very much 😍👏 for the pointers & links to references.
What worked for  me is that, I have uploaded my excel file to SharePoint Documents folder and then I used SharePoint folder connector in Power BI, pointed it to the root folder and pressed on transform button to load all the contents of the sharepoint site.
This video explains in details The best way to connect to a SharePoint Folder to speed up your Excel and Power BI data refresh  , and if you have another table or sharepoint list that you would like to connect to your current report, you can use append query as new function in power query editor. 
The thing is this step might require complete restructure of your visuals including DAX quries assuming you have one, good thing about quires is that you can move them to the new table and they don't require much work.
Good Luck with your report .