Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Why after 1 year excellent work fck PBI begin show this error
Query (step 'Expanded _A_FullFilments') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
only on refresh, no error in transform data, nothing was changed in database?
WTF?
@Digger you are having this issue because you are merging two queries with a different privacy level. You can go to data source settings -> Edit permissions, and verify that all the sources are at either "None" or "Organizational" or "Public" privacy setting. Remeber, that not all privacy level sources can be merged.
You can read more about privacy levels and which source can merge here https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels
@Anonymous no, you are worng im using same privacy levels
@Digger I had a similar problem which I resolved by in a similar manner. The error that I had was following
Anyways, I hope you find a solution that fits your problem
Hi @Digger ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Best Regards
Hi @Digger ,
Please review the following links which has the same problem as yours, hope the solution also can help you solve the problem.
Power BI: Query references other queries or steps, so it may not directly access a data source.
Go to File>Options/Setting>Options
1. Uncheck Require user approval for new native database queries under Native Database Queries in Security options.
2. Ignore Privacy level setting under privacy options
Power Query Errors: Please Rebuild This Data Combination
Query references other queries or steps, so it may not directly access a data
If the above ones can't help you solve the problem, please provide the applied codes of the query which get the error. If this query reference any other query, please also provide the related applied codes. Thank you.
Best Regards
This worked for me, but I am not sure it makes sense to me. Privacy settings were the same for both sources, so why that would start to pop up out of the blue at some point, who knows. Either way, thanks!
@Digger , Not very clear. If it using some reference table or some other tables are used in the refresh. Just refresh and check those tables on which this is dependent, are they giving any errors. If not post that refresh this and check
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |