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

No video

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

Рет қаралды 50,174

Күн бұрын

In this four part series, we will be covering how to connect to the Power BI REST API to create an Power BI admin view of the entire tenant. You can take this data and visualize it to get a 360-degree view of your organization! Details on the series parts below:
Part 1 (Current Video): Connecting to the Power BI Admin REST API to bring in data regarding workspaces, reports, datasets, dataflows, and users.
Part 2: Receiving an access token to refresh the report.
Part 3: Consuming user activity data.
Part 4: Visualizing all of the data we have consumed in the report!
-------------------------------------------------------------------------------------------------------------------
To enroll in my introductory or advanced Power BI courses:
training.bieli...
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Connect with me on Twitter!
/ powerbielite

Пікірлер: 80

@richardconley5343 3 ай бұрын

I feel like the KZfaq 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 3 жыл бұрын

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

@mariobohme8703 4 жыл бұрын

Great. I look forward to seeing the upcoming videos.

@BIElite 4 жыл бұрын

Sounds good, Mario!

@adriancritchley2460 2 ай бұрын

Very useful tutorial thank you so much!

@yagelhen6737 4 жыл бұрын

Great video! looking forward for the next ones

@BIElite 4 жыл бұрын

Thanks Yagel, I just released part 2!

@abrammakgalemele3491 3 жыл бұрын

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

@tejasbrahmbatt5344 4 жыл бұрын

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

@BIElite 4 жыл бұрын

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

@SanataniAryavrat 3 жыл бұрын

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

@BIElite 3 жыл бұрын

Happy to hear that, Manoj :)

@lucianogiusepponi6683 3 жыл бұрын

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

@stevewilliams9753 4 жыл бұрын

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.

@rosecraigie 4 жыл бұрын

This is actually amazing, thank you so much

@Pandora3 4 жыл бұрын

Great video as always, thanks!

@BIElite 4 жыл бұрын

No problem!

@Henrik.Vestergaard Жыл бұрын

This has been truly helpfull - thanks a lot!

@adelina3589 6 ай бұрын

thank you! This is awesome!!!

@rphpacheco 4 жыл бұрын

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

@BIElite 4 жыл бұрын

Thank you Raphael! That means a lot.

@engvictorfarias 2 жыл бұрын

Perfect! Thanks soooooo much ! 💕💕😍😍

@maadala 4 жыл бұрын

Amazing video

@BIElite 4 жыл бұрын

Thanks Rajendra!

@KasiaWichrowska93 3 жыл бұрын

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?

@agasti2007 4 жыл бұрын

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

@BIElite 4 жыл бұрын

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

@agasti2007 4 жыл бұрын

@@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 4 жыл бұрын

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 4 жыл бұрын

@@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 4 жыл бұрын

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

@fujanu 2 жыл бұрын

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."

@federicodefilippi8148 4 жыл бұрын

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

@BIElite 4 жыл бұрын

Coming up in part 2 😊

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

@peterg4130 4 ай бұрын

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?

@felipefrancisco01 3 жыл бұрын

WoW

@tianyueyang511 4 жыл бұрын

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 3 жыл бұрын

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

@papachoudhary5482 4 жыл бұрын

Thanks

@bhagwangaikwad6642 3 жыл бұрын

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

@d8google 4 жыл бұрын

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?

@rahulmejain 3 жыл бұрын

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

@Manish-pb4gr 2 жыл бұрын

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

@AgulloBernat 2 жыл бұрын

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?

@MohitKumar-ri3yv Жыл бұрын

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

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

@federicodefilippi8148 4 жыл бұрын

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

@BIElite 4 жыл бұрын

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

@moisesnuno1565 3 жыл бұрын

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.

@MelissaCornfield 2 жыл бұрын

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

@MrEldjee 3 жыл бұрын

Greaaaaaaaaaat !! Love U

@fujanu 2 жыл бұрын

Is it also possible to make this via a dataflow?

@nvvroenhoven 4 жыл бұрын

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 4 жыл бұрын

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

@federicodefilippi8148 4 жыл бұрын

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

@BIElite 4 жыл бұрын

Exactly, Federico. Glad you got this one sorted.

@cristianocesario 3 жыл бұрын

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 2 жыл бұрын

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

@jiayings2257 4 жыл бұрын

When will the third part come out?

@BIElite 4 жыл бұрын

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

@NirRobinson 4 жыл бұрын

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 4 жыл бұрын

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

@NirRobinson 4 жыл бұрын

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

@yagelhen6737 4 жыл бұрын

@@NirRobinson Happened to me as well ;-)

@BIElite 4 жыл бұрын

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

@greatservice4all 3 жыл бұрын

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 3 жыл бұрын

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

@aloknk2008 2 жыл бұрын

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 2 жыл бұрын

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

@user-ly4tr2mr7z Ай бұрын

I need good wen please

@jefflingen8819 4 жыл бұрын

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

@spen2431 4 жыл бұрын

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 4 жыл бұрын

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

@BIElite 4 жыл бұрын

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

@jefflingen8819 4 жыл бұрын

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

@rosecraigie 4 жыл бұрын

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.