Forum Discussion
Data Refresh Error in PowerBI Workspace
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.
Thanks Expiscornovus. I have retrieved a table from sharepoint and appended with another table from SQL Server. The issue is that am not able to auntomatically refresh due to the table from the sharepoint site as it gives error as stated in the image atatched earlier.
Just wanted to double check what implementation version and viewmode you used for example. This will help troubleshooting and reproducing your issue.
And do you have any specific setup for the account which is used for the connection (MFA, Conditional Access Policy, etc.).