scheduled refresh failed

[HFT]

I have a report where i use 3 API's one to fetch data, 2nd to get the token, 3rd for RLS, even though all are API's and the Data source credentials were set to anonymous and privacy level set to none still  get this error why 
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.

[HFT]

I have an other question related to power query, the report which i am handling has a dynamic token and the API should fetch around 10 lakhs + data and it is fetching till some point till the token is active and throwing error after fetching almost 209mb of data saying "couldnt authenticate with the provided credentials", is that power query not able to fetch the token again once after it expires. pls let me know 

[v-priyankata]

Hi @HFT 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@AntoineW 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.

[AntoineW · Accepted solution]

Hello @HFT,

When you use multiple APIs in the same query (e.g., token API, data API, and RLS API), Power BI applies its data privacy firewall to prevent unintentional data leakage between sources. If privacy levels aren’t explicitly defined or consistent, you’ll see the error:

“Information is needed in order to combine data…”

 

✅ How to fix it

1. Go to Power BI Desktop → File → Options and settings → Options → Privacy.

2. Under Data Load, choose:

   - “Always ignore Privacy Levels and potentially improve performance” (for trusted internal data).

3. Or, keep privacy enforcement but ensure all three APIs have the same privacy level (e.g., Public).

4. In Power Query, make sure all data sources are combined only after authentication tokens are generated — consider staging each API call in a separate query, then referencing them.

 

💡 Tip

This issue is about data combination, not authentication. Even “Anonymous” sources still need consistent privacy levels when merged.

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

Hope it can help you ! 

Best regards,

Antoine