The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a Power BI report created and an On-Premises gateway connection established so I can schedule a daily automatic refresh of the report. It was running/refreshing overnight just fine; however, this morning I received the following error message.
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":"We cannot convert the value null to type Table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: CardsHierarchy.
Cluster URI: WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID: ae18a377-a3f8-40af-9d23-9cf6f62d47a7
Request ID: eaecc3ab-55c9-3f30-e6cc-023208c90451
Time: 2023-05-05 12:49:00Z
Error code: DataAccessError, DataAccessError
Data source error: Unknown error
Cluster URI: https://api.powerbi.com
Activity Id: 127e415e-594d-4475-b62c-5a3ca56ef17d
Request ID: fad79835-d179-4f81-a453-eaaf707852fc
Time: Fri May 05 2023 07:56:26 GMT-0500 (Central Daylight Time)
:
AWS Prod Gateway 2: Received error payload from gateway service with ID 206596: Mashup expression evaluation error. Reason: ..
AWS Prod Gateway 1 : Received error payload from gateway service with ID 206593: Mashup expression evaluation error. Reason: ..
I’m fairly “techy” but this stuff is starting to really get in the weeds for me. Any idea what is causing this?
I am still able to manually refresh the report in PBI Desktop.
I appreciate any help/direction anyone can provide.
Thanks!
Hi @smitht46 ,
Try to check your network connexions, make sure your gateway has access to your data and the oracle port is open to it.
I have also found a similar post, please refer to it to see if it helps you.
Solved: Stack overflow error when refreshing in service, b... - Microsoft Power BI Community
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
31 | |
25 | |
23 | |
22 |
User | Count |
---|---|
64 | |
62 | |
53 | |
38 | |
34 |