Forum Discussion
Error in Power BI Service
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.4 Replies
- AnonymousNot applicable
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.