Forum Discussion

HFT's avatar
HFT
Helper I
10 months ago
Solved

scheduled refresh failed

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...
Need Help
  • AntoineW's avatar
    AntoineW
    10 months ago

    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

AntoineW's avatar
AntoineW
Super User
10 months ago

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