DM_GWPipeline_Gateway_MashupDataAccessError

[Paolo_Zorzi]

Buongiorno a tutti, creando un nuovo report che si basa su di un nuovo set di dati, ricevo questo errore quando cerco di aggiornare il report :

Errore dell'origine dati: {"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":"La chiave non corrisponde ad alcuna riga della tabella."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"TClientiFornitori\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: TClientiFornitori.
URI cluster: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
ID attività: 7272d9e4-6f39-bdff-be89-9cf7b9b0e6cc
ID richiesta: 29dccefa-676b-19f6-0dde-81203cb6d825
Ora: 2023-07-12 09:18:20Z

nonostante che in power bi desktop dando aggiornamenti, viene aggiornato correttamente il report.

Ho aggiornato la versione del gateway, ho variato il livello di privacy in "Organizzativa", ma nulla, da sempre questo problema.

Gli altri report , su set dati diversi funzionano da anni.

[v-yueyunzh-msft · Accepted solution]

Hi , @Paolo_Zorzi 

Thanks for the detailed error message providing and based on my research and query on them, I think the error message you are seeing indicates that the key does not match any row in the table. This error can occur when the name of a table or sheet has been changed or dropped for any reason.

To fix this error, you need to modify the M script for the failed query in Power BI Desktop. You need to go back to the original .pbix file of this report or download the .pbix file again. You can do this by opening the Power Query Editor and navigating to the affected query. If you don't see the exact error, click on Refresh Preview and the same error will be visible there. If you click on Advanced Editor, you will see the M script. You can fix the issue by changing the name to the new name or by clicking on "Edit Settings" button in the alert message.

Here's one blog that also explained the root cause for this error message in detail, please also kindly refer to:

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or E...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Raj_1995]

Hi, I am also facing with the same error. The refresh is working in local and not working in Services and showing the error like above.