Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
2 years ago

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

  • 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's avatar
      Analitika
      Post Prodigy

      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.

  • Anonymous's avatar
    Anonymous
    Not 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 Kong

     

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