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

[Shalini123]

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 1 Data 21/9/2025, 10:55:23 am 21/9/2025, 10:55:48 am 25s Failed (Show)

I tried different Permutation and combination for settimgs privacy level and authentication method, but nothing has worked out. Can anyone pls help here?

[v-priyankata]

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.

[v-priyankata]

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.

[v-priyankata]

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.

[tharunkumarRTK · Accepted solution]

@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!