Forum Discussion

Shalini123's avatar
Shalini123
New Member
1 year ago
Solved

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

Hi,   I am getting an error while refreshing the dashboard in power bi service. My data source includes dataflows, semnatic models from otherworkspace, API call and sharepoint online, When I set p...
  • tharunkumarRTK's avatar
    1 year ago

    Shalini123 

    In your data transformations you might have combined (merge or append) data taken from different sources.

    For example: Merging the query imported from a dataflow with the query imported from sharepoint. 

    When you are doing such operations make sure you set the privacy level correctly, these are the guidelines for setting privacy levels 

     https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/desktop-privacy-levels

     

    My reommendation to you is, to set the privacy levels of all your data source connections to 'Organizational'.

    Open your dataset set settings, expand data source credentails, edit the credentails and change the privacy level. 

     

    Then try to refresh the dataset again. 

     

    Please do note that setting the privacy level in the desktop will not update the privacy level of the datasource connection you created in the power bi service. So, update the credentails in power bi service not in the power bi desktop. (updating the privacy in desktop and re publishing to the service will not help)

     

     

     

     

     

    Connect on LinkedIn

     

     

     








    Did I answer your question? Mark my post as a solution!
    If I helped you, click on the Thumbs Up to give Kudos.

    Proud to be a Super User!