Power BI Service unable to refresh Appended Query

[Robert61]

Receiving this error in Power Bi Service when attempting refresh of Semantic Model. I've set Privacy Levels to none. Still receiving this error. On Power BI Desktop, I am able to query DATABASE1 and DATABASE2, then combine through Appended Query. I am then able to publish to Power BI Service. Power BI Service needs to refresh this data without error.

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":"-214***9"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147***9"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"DATABASE1\"},{\"kind\":\"SQL\",\"path\":\"DATABASE2\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: resultset.

Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net

Time: 2024-10-16 20:37:15Z

[Anonymous]

Hi @Robert61 ,

You can try the following procedure:

1. look at each data source connection in Power BI Desktop and make sure that the privacy level (Public or Organisational) is selected. although Microsoft allows you to select None when you create a connection for a gateway. it does not support it. Please use the same level for all connections.

2. publish the report.

3. in the PBI service, add database connections to your report and ensure that they are set to the same privacy level as the report PBIX. All connections must be the same as PBIX.

4. in the Scheduled Refresh configuration, ensure that the data source connections in the report are mapped to the newly created gateway connections.

5. perform a gateway refresh.

One more note, in PBI Desktop, there is a report option ‘Ignore Privacy Levels’ in the report settings. This only applies to PBI Desktop refreshes. Gateway Refresh will not reference or use it. Therefore, when you think you are telling PBI to ignore privacy levels, only PBI Desktop will ignore them.

More details can be found in the solution to a similar problem:

Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Page 2 - Microsoft Fabric Community

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Elisandro1987]

Bom dia,

Estou com este mesmo problema. Meu Gateway não atualiza os dados no serviço online. Se eu atualizo no desktop e faço a públicação, a atualização online ocorre.