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.
I have a dataset up and running. On the desktop I can click refresh and everything works great. When I publish the dataset and click refresh, I get a Failed message each time similar to below. The gateway has been tested and shows it is good to go. My problem is the table changes each time I try to refresh (1st and 4th lines)
I have removed some letters from the activity ID and request ID
Underlying error code: | -2147467259 Table: Employee Info. |
Underlying error message: | The key didn't match any rows in the table. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.Key: | [Schema = "dbo", Item = "Employees"] |
Microsoft.Data.Mashup.ValueError.Reason: | Expression.Error |
Cluster URI: | WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net |
Activity ID: | e6669d99-5cc2-41ef-...................... |
Request ID: | caf81b71-4ccd-d05e-....................... |
Time: | 2019-09-26 13:45:13Z |
Solved! Go to Solution.
hi, @kattlees
You may refer these similar post:
If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.
Best Regards,
Lin
hi, @kattlees
You may refer these similar post:
If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.
Best Regards,
Lin
Hi Lin,
I do have the same problem. I tried the referred posts but none of them worked for me. I did a test by working on a report on the desktop version, adding each table at time and publishing it to the web service. I found out the report is broken when I append an on premise Gateway table to a BI Dataflow table.
I did rebuild the BI Dataflow from scratch as well as the Power Query tables in the desktop version and none of them worked (I did put attention on the data types).
Any clue of what else may be failing?
Thanks.
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":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[entity = \"fact_Sales\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: fact_Sales.
Thank you. The 4th link worked. I searched and searched but couldn't find it before posting.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |