Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My dashboard sources are mostly open sources (web), one of them is an excel with multiple sheets:
According to Microsoft Docs, a gateway is required for .xlsx, therefore I have set up an on-premise one and it runs correctly. Besides this, I can easily do a manual refresh. But using the scheduled refresh i receive the following error message:
XY 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":"File contains corrupted data."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: XY.
Has anyone experienced a similar situation? How could i fix that? Thanks a lot for your help, i am kinda lost. 🙂
yes I am expereincing the same issue very frustrating
Last refresh failed: Thu Aug 11 2022 12:20:15 GMT-0400 (Eastern Daylight Time)
There was an error when processing the data in the dataset.Hide details
Data source error: | {"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":"File contains corrupted data."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: Illinois. |
Cluster URI: | WABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net |
Activity ID: | 105b864c-394a-4106-b1bd-04d24eb77394 |
Request ID: | f5c0d295-d119-26e2-275f-cf0ccc3b6b1e |
Time: | 2022-08-11 16:20:15Z |
Check you credentials and access DM_GWPipeline_Gateway_MashupDataAccessError"
Just checked again. Both Data source and Gateway connection seem to be ok
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |