Power BI report refresh failed due to some data from dataflow.

Hi lotus99 

You're encountering a refresh failure in a new Power BI report created last week, while all older reports continue to refresh successfully. The error message indicates a problem with the way data is being combined in the new report, specifically pointing to a dataflow named df_Corptax_Entity. The message suggests that the query Load_PRVUSPPO_2024 is attempting to reference or expand steps from df_Corptax_Entity in a way that Power BI considers unsafe or unsupported during scheduled or service refresh. This typically happens when queries from different data sources—or even dataflows—are combined without enabling "Allow data preview to download in the background" or without properly managing Privacy Levels. In your case, it appears that the combination of steps within the report is being interpreted as violating Power BI’s privacy isolation rules, especially if you're referencing or expanding queries that rely on other query steps indirectly. This issue often does not occur in Desktop during development but becomes apparent when refreshing in the service. To resolve it, you can try enabling “Fast Combine” by setting the Privacy Levels for your data sources to "Organizational" or "Public" in the Power BI Desktop under File > Options and Settings > Options > Privacy. Additionally, ensure that your queries are not nested or referencing each other in a way that creates implicit data source combinations. If the issue persists, refactor the query to separate or flatten dependencies before merging or expanding, or consider creating an intermediate dataflow to pre-process and simplify data dependencies.