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.
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 for all the suggestions but its still haven't worked!
I would like to give more context to the issue.
I have a report that has a query that contains historical data saved in a sharepoint file and another query containing latest data pulled from SQL Server. They both have same columns and are appended to a table in the report.
I am able to manually refresh the report in powerbi desktop and service but the automated data refresh using data refresh schedule keeps giving me this error
"
An error occurred while processing the data in the semantic model.
Refresh failed:
ASC Netcall Dashboard has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>SharePoint: Request failed: The underlying connection was closed: An unexpected error occurred on a send.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"<ccon>https://officesharedservice.sharepoint.com/sites/BI-Corporate</ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Agent Summary Breakdown"
I would appreciate if anyone has had this issue and got a permanent solution.