Forum Discussion
Refresh failure
Hi Team,
Could anyone please help on why i am keep receiving the error for one of my refresh?
"{"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":"5 arguments were passed to a function which expects between 2 and 4."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Arguments","detail":{"type":1,"value":"{Table.FromRecords({}), \"Index\", 1, 1, number}"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table:XXXX"
Hi A30007479 ，
What data source are you connecting to? What is the connectivity mode (Import, DirectQuery or Live Connection)? Did you get this error message in Power BI Desktop or Service?
Here are some threads with similar refresh issue to yours, check them out for solutions. Hope they can help you.
DM_GWPipeline_Gateway_MashupDataAccessError
Changing the Privacy Level in Power BI online as solved the refresh issue.
DM_GWPipeline_Gateway_MashupDataAccessError
Rebooting the server cleared it up.
we solved this problem by reset to gateway
Best Regards
9 Replies
it is still not working.. If i refresh through PBIX it works correctly.. it is just not refreshing from Desktop
Hello! I have the same problem, can you give me more details how you solved the problem with the index function? Best regards.
This may be late to the game for another possible solution for people but I just had this same issue and none of the proposed solutions were working. Despite the vague error messages it wound up being that I needed to update my Connection credentials.
A30007479 , Can you open and check power query , by refreshing a tables by one for error. I see issue with one of the step
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
Hi A30007479 ，
What data source are you connecting to? What is the connectivity mode (Import, DirectQuery or Live Connection)? Did you get this error message in Power BI Desktop or Service?
Here are some threads with similar refresh issue to yours, check them out for solutions. Hope they can help you.
DM_GWPipeline_Gateway_MashupDataAccessError
Changing the Privacy Level in Power BI online as solved the refresh issue.
DM_GWPipeline_Gateway_MashupDataAccessError
Rebooting the server cleared it up.
we solved this problem by reset to gateway
Best Regards
It is Import Query. All good. i managed to fix it. the issue was with Index function. i just had to remove the last parameter.
Hello, what do you mean by the last parameter?
You should check the privacy level of the gateway, in my case it was connected to two different data sources, simply change the privacy level to "organizational" of the two gateways. The problem was fixed and my dashboard updates correctly
Thank you. I had the same error and doing what you say from the privacy level to "organizational" was fixed. 👍
