Building a Power BI Admin View [Part 1]: Connecting to Data from the REST API

[@CarolPautsch-w8v]

This is amazing! I haven't even gotten to parts 2 and beyond, but this is a better walkthrough on this than anything I've seen. It's always the small, seemingly insignificant things that trip us up, and you were very thorough.

[@richardconley5343]

I feel like the KZbin algorithm failed me. I can't believe its taken me 3 years to find this. This would have been amazing to have as a beginner. A lot of hard hours learning how to do this and this video would condensed my learning curve greatly. Really great content.

[@johns8903]

This very helpful. I can't say Thank You! Enough. We live in a world where people give knowledge generously and freely.

[@andres777video]

Best 4-Video series on this API topic, bar none.! specially 3 and 4

[@mariobohme8703]

Great. I look forward to seeing the upcoming videos.

[@BIElite]

Sounds good, Mario!

[@abrammakgalemele3491]

Thank you Parker. You have helped me with my work BI Task. Superb stuff. Thanking you for Johannesburg, South Africa.

[@yagelhen6737]

Great video! looking forward for the next ones

[@BIElite]

Thanks Yagel, I just released part 2!

[@tejasbrahmbatt5344]

Exceptional.. Never explored rest apis this way.. Keep enlightening.. :)

[@BIElite]

Yes it’s quite fun to dig around the API and see what data can be returned! Stay tuned for the following parts.

[@shraddhaverma4795]

Very useful information 🎉

[@stevewilliams9753]

Cool content as always. Although its a pity you didnt briefly show the final report to give the viewer a better idea of why your 4 part series is important.

[@rphpacheco]

Thank you so much for sharing your knowledge! I really admire your work! Congratulations!

[@BIElite]

Thank you Raphael! That means a lot.

[@lucianogiusepponi6683]

OMG! I've trying for weeks! Thank's!!

[@rosecraigie]

This is actually amazing, thank you so much

[@SanataniAryavrat]

this is awesome source of information.... thanks for such a great tutorial...

[@BIElite]

Happy to hear that, Manoj :)

[@adriancritchley2460]

Very useful tutorial thank you so much!

[@Pandora3]

Great video as always, thanks!

[@BIElite]

No problem!

[@peterg4130]

So after I hit "Remove Errors" in the Datasets step, my Power BI just hangs. It doesn't implement that step. Just gets stuck on the spinning icon. What could be causing this?

[@Henrik.Vestergaard]

This has been truly helpfull - thanks a lot!

[@fujanu]

Thanks a lot for the video. In Azure I get the positive Code 200. But when I want to connect with Power BI I get asked "Select which level to apply these settings to". Whatever I choose, I get an error message "Details: "Access to the resource is forbidden."

[@agasti2007]

Nice one. Eagerly waiting for how you keep grabbing the latest JWT!

[@BIElite]

Glad to hear that you're interested! This is a relatively dry topic for some.

[@agasti2007]

@@BIElite i had for the longest time, been looking for a nice and easy way to grab JWTs in PowerQuery. There is a lot on these lines I could deliver to my org and definitely learn a lot doing so.

[@BIElite]

Spoiler: I like the method a lot but there still is a manual step involved. As stated in this video, you can't combine multiple web data sources in a single query. So the flow is like this 1) Grab JWT 2) Paste the new JWT in a parameter 3) Reference the parameter in the other queries. You can work around this if you save the JWT to a file on sharepoint or something, but that would take a lot of setup.

[@agasti2007]

@@BIElite I actually had thought of something but didn't get time to advance on it. My thought involved running a CRON job or scheduling a python/powershell script to generate JWT and dump it into a flat file on a secure location and keep replacing the file at a set frequency. PBI would just point to that file to grab the token. I would wait for your next video! You run a cool channel.

[@BIElite]

Whoa... thanks for asking about this. I just figured out a way to make this fully automated! Video probably coming Thursday ;)

[@KasiaWichrowska93]

This is fantastic! Kudos to you for making this video! When I'm trying to envoke Users function to add it in as a custom function into Users table I get this error Formula.Firewall: Query 'Users' (step 'Invoked Custom Function') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. Any ideas?

[@adelina3589]

thank you! This is awesome!!!

[@engvictorfarias]

Perfect! Thanks soooooo much ! 💕💕😍😍

[@federicodefilippi8148]

Great stuff. How to publish to the service and schedule refresh? Thanks!

[@BIElite]

Coming up in part 2 😊

[@AgulloBernat]

I have a brand new PPU with a single workspace and 1 dataset. I run the call from the api documentation site and I'm getting a 401 result . cache-control: no-store, must-revalidate, no-cache content-type: application/octet-stream pragma: no-cache any clues?

[@Manish-pb4gr]

What tool have you used to get the result of GET command, I am not getting that option on Chrome?

[@AndyKabeer]

Hi, great video, is it possible to track what filter conditions were used while running a report (especially time filter ) by a user using an audit log?

[@d8google]

Thanks for this. When I try to get data from using the JWT (using Power BI Admin user), It does not work. OK button on the connection "From Web" keeps spinning for a very long time until I am tired. Is there any other permission or setting I need to change to fix this?

[@maadala]

Amazing video

[@BIElite]

Thanks Rajendra!

[@bhagwangaikwad6642]

Need to any setting enable for this. I am trying but I am getting the forbidden resource error. Could you help on this?

[@tianyueyang511]

Thank you for your video, I'm trying to follow alone, however, I keep getting access to the resource is forbidden message after I connect to the API. I was able to get data once, and then when I refresh it, the same message appear again. I have tried to clear the permission, and reconnect, it didn't work. Any idea why does this happen?

[@bertalanronai2182]

The Bearer key is only good for an hour it seems like.

[@botondbaji3360]

I have a problem. I'am Power BI administrator , everything else works fine but when I try to invoke Groups GetGroupUsersAsAdmin acces forbidden. I also use everything else as in the video no ideaa..

[@rahulmejain]

What if i need to find - whether a scheduled refresh has been applied on my dataset or not ? if applied, what is the frequency

[@MohitKumar-ri3yv]

Where this data is being stored(all extracted tables) ?

[@MelissaCornfield]

Any way to do something similar with this API : Datasets - Discover Gateways In Group

[@federicodefilippi8148]

Getting "too many request" error for reaching Datasets api calls limit. Any way around this? Thanks

[@BIElite]

See part 2, we cover a different method that accounts for this :)

[@moisesnuno1565]

Thank you, by any chance do you know how can I get the user access permissions by report with out admin access? because I can get it for the workspace group but not by report.

[@nvvroenhoven]

Any idea why I get the "The Authorization header is only supported when connecting anonymously" error? I got the bearer token from the Rest API's site where I did get a response.

[@federicodefilippi8148]

same happened to me! were you able to solve it? Thanks

[@federicodefilippi8148]

found it. You need to edit Data Source properties and set Anonymously in credentials.

[@BIElite]

Exactly, Federico. Glad you got this one sorted.

[@cristianocesario]

Great post! I managed to get workspaces, datasets, reports and dataflows, but when I try to get users it gives me error 401. Any ideas of what might be happening? My user is tenant admin and capacity admin.

[@theevilnen]

U need to be Office365 (MS365) Portal admin to get users probably?

[@fujanu]

Is it also possible to make this via a dataflow?

[@jiayings2257]

When will the third part come out?

[@BIElite]

Soon! I had a couple other videos that I needed to release. Either next Tuesday or the following.

[@NirRobinson]

Hi, Thanks for great series. I encounter an error "Details: "Access to the resource is forbidden."" even though I succeed to query on the web (same as your video). The credential I choose is anonymous - is that OK? ( I tried the other credential but got error MSG also)

[@yagelhen6737]

Anonymous is great - no credentials needed. it worked for me

[@NirRobinson]

@@yagelhen6737 10xxx , I found the problem , i copy only part of the token (double click and there is a spae :-(()

[@yagelhen6737]

@@NirRobinson Happened to me as well ;-)

[@BIElite]

I just released part 2 today which makes this part a lot easier.

[@MrEldjee]

Greaaaaaaaaaat !! Love U

[@papachoudhary5482]

Thanks

[@felipefrancisco01]

WoW

[@aloknk2008]

Great Video, But after duplicating workspace and invoking custom function i get an error, " Expression Error: Access to Resource is forbidden " Any suggestions please? highly appreciate

[@travelwithdharak]

I think your token expires. so you will need to refresh the bearer token part in your "advanced editor" section :)

[@greatservice4all]

Wow, the video is great, but the concept IS RIDICULOUS !!! Why can't MS create a connation to the admin data that is as simple as connecting to a SQL database? Lets make the most Convoluted ass backwards process possible! Simply unbelievable!

[@BIElite]

Thank you! Given that this is a pretty standard API, I think MS is doing a good job. I really don't like the way you have to refresh your access token shown in part 2 of this series. That's a whole separate issue lol

[@PembaSherpa-m8f]

I need good wen please

[@jefflingen8819]

Getting Privacy Warning when invoking 'Get User' then "couldn't authenticate with credentials provided'. ?? All others work just fine.

[@spen2431]

I do to..... Everything else work as you said. Its just the USERS. - Thanks SO much for taking the time to share this stuff.

[@spen2431]

Fixed my error. Removed a couple of "erroneous" groups and now works fine. Will find out why I needed to remove some groups.

[@BIElite]

Yes, this was my exact issue as well. Both of the workspace that failed were template apps, but not all template apps failed.

[@jefflingen8819]

Thought I had filtered all those away. I'll look closer. Thanks!

[@rosecraigie]

I had the same issue too, I realised it was because I didn't have access to all of the workspaces I was trying to get the users for and since we couldn't do it as admin, I was denied.