Formula Firewall Error

[Anonymous]

Hey all,

I have viewed some posts (including https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ ) but i still don´t get it.

I have an Excel workbook containing file names:

I import FileA to PowerBi:

and i get:

Now i run in:

I just can´t find a workaround!

Is there any way for dynamic adressing. I run in the same prolems when interaction with my api...

Thanks in advance.

Regards,

Luis

[mwegener]

Hi @Anonymous ,

is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

check this out.

https://blog.crossjoin.co.uk/2017/07/04/data-privacy-settings-in-power-bipower-query-part-4-disabling-data-privacy-checks/

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.