Forum Discussion
Refresh error: Information is needed in order to combine data.
- 1 year ago
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!
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
|