Forum Discussion
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 provacy level to "None " I get error :
| Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface |
After this I changed the privacy level to "Organisational for all data sources listed above and then error change to this :
| {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We cannot refresh this dataset because the dataset contains calculated tables or calculated columns based on data from a Single Sign-on (SSO)-enabled Direct Query data source. Please configure the dataset to use an explicit connection with granular access control to access this data source and then try again."}}],"exceptionCulprit":1}}} | ||||||||
| Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net | |||||||
| Activity ID: | e6fe55db-7fb0-651c-d204-916b6ae95dbc | |||||||
| Request ID: | 6f4464fe-f107-108a-491d-d09a33433da6 | |||||||
| Time: | 2025-09-21 05:25:48Z | |||||||
| Details | # Type Start End Duration Status Details
|
I tried different Permutation and combination for settimgs privacy level and authentication method, but nothing has worked out. Can anyone pls help here?
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!
4 Replies
- tharunkumarRTK
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
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!
Hi Shalini123
Thank you for reaching out to the Microsoft Fabric Forum Community.
tharunkumarRTK Thanks for the inputs
I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi Shalini123
I wanted to check if you had the opportunity to review the information provided by users Please feel free to contact us if you have any further questions.
Hi Shalini123
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
