Forum Discussion

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
3 years ago
Solved

PowerBI report in app.PowerBI.com does not refresh data (linked to Onedrive files)

Hi i have uploaded a report in  which is linked to Excel files on Onedrive, which i then weekly update.

 

When i refresh the Report on Onedrive, it works fine, however when i try to refresh the Published report, new data is not added.

 

I can see this error message :

 

  • Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
  • Cluster URIWABI-NORTH-EUROPE-L-PRIMARY-redirect.analysis.windows.net
  • Activity IDab56a557-336a-4764-bf13-24eee97fc867
  • Request IDf095f19e-ff94-b188-16ff-ef18b9d8ee8a
  • Time2023-07-03 07:14:57Z

When i try to manually refresh, it does not either

 

I would like avoid update Report on Onedrive and then Publish each time, if can you just update the Published report.

 

Any hints?

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi bilingual ,

    If you created your datasets and reports based on a Power BI Desktop file, Excel workbook, or comma separated value (.csv) file on OneDrive or SharePoint Online, Power BI performs another type of refresh, known as OneDrive refresh. For more information.

    Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

     

    For more details, you can read related document: Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi bilingual ,

    If you created your datasets and reports based on a Power BI Desktop file, Excel workbook, or comma separated value (.csv) file on OneDrive or SharePoint Online, Power BI performs another type of refresh, known as OneDrive refresh. For more information.

    Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

     

    For more details, you can read related document: Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.