Datasets Failed to refresh

[dc7669]

Hi,

A PowerBI dataset I have failed to refresh.  I wonder why. 

 

The data gateways itself is running good. 

I created another report getting data from the same data source and it runs OK.  

Any idea on how to fix it?  

#DB1# and #DB2# are the names of my databases I am connecting to.  

 

Last refresh failed: Sat Mar 21 2020 09:25:06 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":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"#DB1#"},{\"kind\":\"SQL\",\"path\":\"#DB2#"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: ER_CURRENT_INCIDENT_REPORT_V.
Cluster URI:	WABI-US-GOV-VIRGINIA-redirect.analysis.usgovcloudapi.net
Activity ID:	179dbc6f-b3e8-4b0d-9c09-d66231738e91
Request ID:	e14db44c-a099-27cf-0064-88e6b6ee6e24
Time:	2020-03-21 13:25:06Z

[dc7669]

I opened a support ticket about it.  

The Microsoft contractors were looking at permission setting of my different data sources in my Data Gateway, but I think it is not the cause of the error as the Power BI Desktop still can update without any problem.  When I published from Power BI Desktop to Power BI Service, the data is all current.   ut, if I were to refresh in Power BI service, the error occurred.

Also, I published the same dataset from Power BI Desktop to Power BI Service without the "Merge tables".  Then, Power BI service can refresh without problems.  

Thus, it seemed to me that the "merge tables" function is causing the failure. 

I suspect this is caused by some backend stuffs, which may take the next update to fix.  

I guess my temporary solution is manual publishing of the Power BI Desktop to Power BI Service.  

dc7669

[arif13]

Hi, were you able to solve the problem?

[dc7669 · Accepted solution]

After a few support ticket calls, the solution is found!  

In Power BI Web, Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked! 

 So, on this screen, scroll to the bottom,

expand Advanced Settings, and Set the Privacy Level setting for all my data sources to "Public" and then the Scheduled Refresh worked! 

Hope this helps everyone who has this problem! 

dc7669

[LukeMcManagan]

Worked for me! Thank you

[Anonymous]

Hi, 

I cant find this screen in Power BI Web.

[dc7669]

From Setting (the gear icon) in top right of Power BI Web.  From the menu, select "Manage Gateway".  Then, Expand "Gateway Cluster" and then click on one of the Data source.  Then, you will see the above screen.  

[Anonymous]

Hi, @dc7669 

I have exactly the same error while trying to access the data from online sources.
Sometimes it runs fine, other times it gives the same error.

Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":

.

.

{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySe...}}} Table: Append1.

[v-gizhi-msft]

Hi,

Hope these can help:

https://community.powerbi.com/t5/Service/Enterprise-gateway-quot-cannot-connect-to-the-mashup-data-s... 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot 

Best Regards,

Giotto Zhi

[Greg_Deckler]

Not a ton to go on except that it appears it is having trouble with this table or view ER_CURRENT_INCIDENT_REPORT_V combining it with some other data. Perhaps there is a Merge or Append that is causing it trouble. Not a ton to go on, I would recommend a support ticket.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".