Error in Power BI Service

[Analitika]

Hello,

I have published .pbix file to Power BI service online and getting this error. I tried to make same privacy in desktop version and power bi service. And after changes nothing changed, same error. So how I could resolve my error. I also have re-installed on-premises personal gateway.

{"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. Please specify a privacy level for each data source."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"MySql\",\"path\":\"88.119.221.244</ip>:33067;3t-favs\"},{\"kind\":\"File\",\"path\":\"C:\\\\PBI_SERVER\\\\Smarton\\\\sas_kodai_FULL_3t.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: account_category.

[v-kongfanf-msft]

Thanks for the reply from @GilbertQ , please allow me to provide another insight:

Hi @Analitika ,

For this type of reported problem, it is usually caused by privacy settings.

After reinstalling the Personal Gateway, then create the same privacy in the Power BI Desktop and in the service.

You can refer to below document:

Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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

[GilbertQ]

Hi @Analitika 

Can you please enter that the privacy settings on all your data sources are set to the same level? For example? or privacy settings should be set to organisational.

[Analitika]

Hello,

Actually I have tried to match privacy levels in service and desktop version too but still getting same error. Also I have tried to reinstall gateway but nothing changed.

[Digger]

@Analitika not you not ryed and not sett them all or set them wrong