Webinar: Be a Full Stack #PowerBI Jedi

If you missed my webinar today, here it is:

Download the solution file (.pbix) here.

More resources:

Star Wars Challenge – Row Level Security in Power BI here.

Our source data is provided by SWAPI, The Star Wars API: https://swapi.co/


  1. Anonymous Reply

    Dear Gil,

    Thank you for this wonderful tutorial, as a beginner I see the possibilities as I better understand what I do not understand 😉

    While following along I however encountered some errors while Invoking the custom pagination function:

    Formula.Firewall: Query ‘People’ (step ‘Invoked Custom Function’) references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

    When I downloaded your example: I also encountered them in the query editor. Could you give me a pointer as to how to solve this?

  2. Bjoern Sjut Reply

    Awesome talk, Gil. Thanks for sharing that!

    You mentioned during the talk that you’d like into the aspects of scheduled refreshes of queries that are parameterized. – would be awesome, if you could add some additional insights here of what you’ve learned-

  3. Anonymous Reply

    I don’t see the *.pbix files. It downloads a zip file full of a bunch of other files like the datamashup, datamodel, diagramstate, etc. How do I open this in Power BI?

  4. Fah Zah Reply

    In the BMI 3 approach why do we need to use the VALUES of the Table instead of the table as the first input/variable of the AVERAGEX() function? I did try bmi 3 = AVERAGEX(People;People[mass]/People[height]^2) and it does return the same BMIs but for some reason we do not agree on the total BMI. i get 31,07 and your video has 32.05. can you please explain this and especially why we do need the VALUES(People) instead of People??

    • Gil Raviv Post authorReply

      Using People should have the same results as VALUES. Perhaps in my Video I filtered out characters with missing mass and height, and as a result the average is different?

  5. Fah Zah Reply

    @Gil Raviv thank you for the fast response!

    , how we can extend this so that we can pull same data from the web on daily basis for e.g. a list of stock prices and build a historical database with the daily prices for those stocks using this tools?

Leave a Reply