Forum Discussion

j_w's avatar
j_w
Icon for Helper IV rankHelper IV
9 years ago
Solved

Refresh error message: Information is needed in order to combine data

I still have the error described here     The on-premises data gateway is up-to-date, version number 14.16.6423.3   In the Power BI Desktop, I have made following setups for the sales repo...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi j_w

     

    Thanks for those details.


    When you Added the data source in the Gateway on the Power BI Service, what did you set the privacy settings to under Advanced? It should also be set to None for each of the data sources

     

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi j_w

 

It appears that the error is because you have got two different data sources with two different Privacy Settings.


What I would suggest doing is in your Power BI Desktop file go into the Options and set the Privacy to None or Ignore. This is desgined by default, so if there is a privacy mismatch for the data to not be loaded.

 

This blog post will also give you more details around the Privacy settings

https://blog.crossjoin.co.uk/2017/07/10/data-privacy-settings-in-power-bipower-query-part-5-the-inheritance-of-data-privacy-settings-and-the-none-data-privacy-level/

j_w's avatar
j_w
Icon for Helper IV rankHelper IV
9 years ago

Hi GilbertQ

 

Thanks for your reply.

 

In my post, I have mentioned the following settings:

 

I think these are the settings that you suggested, right?

 

But such kind of setting didn't work.

 

Thanks.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi j_w

     

    Thanks for those details.


    When you Added the data source in the Gateway on the Power BI Service, what did you set the privacy settings to under Advanced? It should also be set to None for each of the data sources

     

    • j_w's avatar
      j_w
      Icon for Helper IV rankHelper IV
      9 years ago

      Hi GilbertQ

       

      You are amazing :)

       

      On the Power BI Service website, I found one data source's privacy level is set to None and the others are Organizational.

       

      After I changed the None one to Organizational (by deleting it and creating another Organizational one), the report refresh works again.

       

       

       

      There are two questions though:

      1. Currently, I have set the Privacy Level in the report file to None or Ignore, but on the Power BI Service website, all data sources are set to Organizational, and this works fine. Does this mean the Privacy settings in Desktop and Service are independent?

       

      2. Why I could not change the Privacy setting from None to Organizational on the Power BI Service website? I have to delete it and create a new one with privacy level set to Organizational.

       

       

      Thanks.

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        Thanks j_w

         

        With regards to your questions, from my understanding the Privacy settings should be the same between the desktop and the service.

         

        When you create a data source in the Gateway it appears that the privacy setting cannot be modified and needs to be re-created and have the new privacy setting applied in that way.