If you missed my webinar in February, today is a great opportunity to watch it, and practice your Power BI skills with Star Wars data:
Download the solution file (.pbix) here.
Star Wars Challenge – Row Level Security in Power BI here.
Our source data is provided by SWAPI, The Star Wars API: https://swapi.co/
Trying to learn PowerBI, and this is a great walkthrough, but as soon as I invoked the function, I got an error I couldn’t resolve…
“Formula.Firewall: Query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.”
When I download the solution, I get the same error in both ‘People’ and ‘Species’ queries.
What might be happening here?
You should go to File -> Options and Settings -> Options and in Privacy under Current File enable “Ignore Privacy Levels…”. Then refresh again. For a more advanced solution go here: https://datachant.com/2018/02/27/powerbi_jedi_starwars-2/