Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data Refresh Error in PowerBI Workspace

Hi Everyone,   I have been getting this data refresh error in one of my reports in the powerbi service. I am able to manually refresh in powerbi desktop and in powerbi service but the scheduled ref...
Dataflow
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 

     

    This error should be caused by the the Data Souce name didn't completely match (different cases) between the queries and the gateway, because the power BI could not find a matching pair of Table for the Dataset.

     

    You can open the Advanced Editor in the power query and check the Data Source name and table name in the second line. Make sure that the Data source name and Table name referenced here match of a Data Source in the Enterprise Gateway.

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Expiscornovus's avatar
Expiscornovus
Most Valuable Professional
1 year ago

Hi Anonymous,

 

Can you share a bit more details about your setup? In the first part you mention your retrieve a table from SharePoint, are you using the SharePoint.Tables for that?

https://learn.microsoft.com/en-us/powerquery-m/sharepoint-tables

 

Or are you using a different Power Query M function to connect to your SharePoint data source?