Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
my power bi report was working great, until i connected to a sharepoint folder to pull in some excel files, and to merge them into a single query..
ever since pulling in the excel files, i am getting "Formula.Firewall: Query 'XYZ' (step 'Changed Type') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." ,
as well as
"Unexpected Error, Evaluation was cancelled"
these errors are annoying because if i click refresh, or click through my "applied steps", then click refresh, they go away..
if i don't click refresh in my power query editor, and make sure all my sources are clear of errors, my report won't refresh on the report view.
its just annoying and time consuming to deal with, since i have ~14 queries, plus the 4 spreadsheets from the sharepoint folder, and the only thing i have to do is click "refresh" one by one until each error disappears.
does anyone know a solution or setting or something to make it better?
Solved! Go to Solution.
you can change the security settings for the workbook, it may also help if all the sources you use have the same security status (Public/Organizational etc.)
Hi @aar0n,
Please also refer to Formula-Firewall-workarounds and Problem-Merging-Queries-Formula-Firewall-Query-references-other.
Best Regards,
Dale
you can change the security settings for the workbook, it may also help if all the sources you use have the same security status (Public/Organizational etc.)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |