Forum Discussion

alexkelly101757's avatar
alexkelly101757
Frequent Visitor
6 years ago
Solved

Information is needed in order to combine data Table: machine_shop_OEE.

Hello,   In Power BI desktop I can update the database without error.  However, when I publish to the cloud power bi it gives me the message below when refreshing the data source.    Hide On d...
Show and Tell
Tips and Tricks
  • alexkelly101757's avatar
    alexkelly101757
    6 years ago

    Spoke to Microsoft support and found the problem.   Even though all the settings were correct in the destkop.  I had to reset the permsions on the power bi cloud (service) side by clicking edit credentials and setting he privacy settings and entering the password (see screen shot below).  Its now refreshing fine.  

     

    Thanks for the help 

     

     

     

     

    Thanks 

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  alexkelly101757 

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.

And you need do this in manage gateway too.

and here are some similar posts for you refer to:

https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data/td-p/574058

https://community.powerbi.com/t5/Service/Information-is-needed-in-order-to-combine-data-Table-without/td-p/716747

https://community.powerbi.com/t5/Service/Refresh-error-message-Information-is-needed-in-order-to-combine/td-p/234722

 

Regards,

Lin

alexkelly101757's avatar
alexkelly101757
Frequent Visitor
6 years ago

Thank you,

 

theres only 2 data sources and they are both set to organizational.  im not using a gateway for this pbix.  one is azure and the other is sharepoint online. 

 

- I download the PBIX file and change the name and reuploaded as suggested in the articls posted, still same error.  

- File > Options and Settings > Options:
   GLOBAL > Privacy: have set the Privacy Levels to "Always ignore Privacy Level Settings"
   CURRENT FILE > Privacy: have set the Privacy Levels to "Ignore the Privacy Levels and potentially

- File > Options and Settings > Data source settings:

    - i have set them all to none, 

    - i have also tried setting them all to organizational. 

    - i have also tried setting them all to public.

    - i have also tried setting them all to private 

 

 

Please help this is a really frustrating problem!   Much appreciated.  

 

latest error : 

 

Message: Information is needed in order to combine data Table: machine_shop_OEE.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: a71e30b4-737e-4446-8637-ce260a73d6d3
Request ID: 544cc737-70a4-c1a0-7e54-ac90fb5a5496
Time: 2020-02-06 10:03:06Z

    • alexkelly101757's avatar
      alexkelly101757
      Frequent Visitor
      6 years ago

      Spoke to Microsoft support and found the problem.   Even though all the settings were correct in the destkop.  I had to reset the permsions on the power bi cloud (service) side by clicking edit credentials and setting he privacy settings and entering the password (see screen shot below).  Its now refreshing fine.  

       

      Thanks for the help 

       

       

       

       

      Thanks 

       

       

       

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        hi  alexkelly101757 

        It's pleasant that your problem has been solved, please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.   😁

         

        Regards,

        Lin