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/
Webinar: Be a Full Stack #PowerBI Jedi
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?
Thank you for he feedback. In File > Options > Privacy > Select “Ignore Privacy Levels…”
More about it here: https://datachant.com/2018/02/27/powerbi_jedi_starwars-2/
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-
Thank you Bjoern for the great idea. Check out the follow-up for the solution:
https://datachant.com/2018/02/27/powerbi_jedi_starwars-2/
Learned a lot from this video, Thank you!
Thank you Junmin.
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?
Did you try to download this file: https://datachant.com/public/Star%20Wars%20Demo.pbix. I tested it again. It is saved as a pbix file, and should be open with your Power BI Desktop.
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??
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?
@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?