Webinar: Be a Full Stack #PowerBI Jedi

12 comments

1. 

   Anonymous February 22, 2018Reply

   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?

   • 

     Gil Raviv Post authorFebruary 22, 2018Reply

     Thank you for he feedback. In File > Options > Privacy > Select “Ignore Privacy Levels…”

     • 

       Gil Raviv Post authorFebruary 27, 2018

       More about it here: https://datachant.com/2018/02/27/powerbi_jedi_starwars-2/

2. 

   Bjoern Sjut February 23, 2018Reply

   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-

   • 

     Gil Raviv Post authorFebruary 27, 2018Reply

     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/

3. 

   Junmin Wu February 25, 2018Reply

   Learned a lot from this video, Thank you!

   • 

     Gil Raviv Post authorFebruary 27, 2018Reply

     Thank you Junmin.

4. 

   Anonymous March 18, 2018Reply

   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?

   • 

     Gil Raviv Post authorMarch 18, 2018Reply

     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.

5. 

   Fah Zah August 20, 2018Reply

   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 authorAugust 20, 2018Reply

     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?

6. 

   Fah Zah August 21, 2018Reply

   @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?