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.
I feel like the UA-cam 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.
@@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.
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.
@@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.
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.
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."
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?
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?
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?
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?
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?
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.
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?
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..
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.
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)
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.
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!
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
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.
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
![Building a Power BI Admin View [Part 2]: Obtaining a Refreshable Access Token](http://i.ytimg.com/vi/2RZkc_qrV1g/mqdefault.jpg)
![Building a Power BI Admin View [Part 2]: Obtaining a Refreshable Access Token](/img/tr.png)
![Building a Power BI Admin View [Part 3]: User Activity Data!](http://i.ytimg.com/vi/Z4E2jSZ4r6A/mqdefault.jpg)
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.
I feel like the UA-cam 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.
Best 4-Video series on this API topic, bar none.! specially 3 and 4
This very helpful. I can't say Thank You! Enough. We live in a world where people give knowledge generously and freely.
Very useful information 🎉
Great video! looking forward for the next ones
Thanks Yagel, I just released part 2!
Great. I look forward to seeing the upcoming videos.
Sounds good, Mario!
this is awesome source of information.... thanks for such a great tutorial...
Happy to hear that, Manoj :)
Exceptional..
Never explored rest apis this way..
Keep enlightening.. :)
Yes it’s quite fun to dig around the API and see what data can be returned! Stay tuned for the following parts.
OMG! I've trying for weeks! Thank's!!
Thank you Parker. You have helped me with my work BI Task. Superb stuff. Thanking you for Johannesburg, South Africa.
Very useful tutorial thank you so much!
This is actually amazing, thank you so much
This has been truly helpfull - thanks a lot!
Great video as always, thanks!
No problem!
Thank you so much for sharing your knowledge!
I really admire your work!
Congratulations!
Thank you Raphael! That means a lot.
thank you! This is awesome!!!
Perfect! Thanks soooooo much ! 💕💕😍😍
Nice one. Eagerly waiting for how you keep grabbing the latest JWT!
Glad to hear that you're interested! This is a relatively dry topic for some.
@@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.
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.
@@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.
Whoa... thanks for asking about this. I just figured out a way to make this fully automated! Video probably coming Thursday ;)
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.
Amazing video
Thanks Rajendra!
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."
Great stuff. How to publish to the service and schedule refresh? Thanks!
Coming up in part 2 😊
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?
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?
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?
The Bearer key is only good for an hour it seems like.
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?
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?
Getting "too many request" error for reaching Datasets api calls limit. Any way around this? Thanks
See part 2, we cover a different method that accounts for this :)
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.
same happened to me! were you able to solve it? Thanks
found it. You need to edit Data Source properties and set Anonymously in credentials.
Exactly, Federico. Glad you got this one sorted.
What if i need to find - whether a scheduled refresh has been applied on my dataset or not ? if applied, what is the frequency
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?
Need to any setting enable for this. I am trying but I am getting the forbidden resource error. Could you help on this?
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..
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.
Where this data is being stored(all extracted tables) ?
When will the third part come out?
Soon! I had a couple other videos that I needed to release. Either next Tuesday or the following.
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)
Anonymous is great - no credentials needed. it worked for me
@@yagelhen6737 10xxx , I found the problem , i copy only part of the token (double click and there is a spae :-(()
@@NirRobinson Happened to me as well ;-)
I just released part 2 today which makes this part a lot easier.
What tool have you used to get the result of GET command, I am not getting that option on Chrome?
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.
U need to be Office365 (MS365) Portal admin to get users probably?
Any way to do something similar with this API : Datasets - Discover Gateways In Group
Greaaaaaaaaaat !! Love U
Is it also possible to make this via a dataflow?
WoW
Thanks
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!
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
Getting Privacy Warning when invoking 'Get User' then "couldn't authenticate with credentials provided'. ?? All others work just fine.
I do to..... Everything else work as you said. Its just the USERS. - Thanks SO much for taking the time to share this stuff.
Fixed my error. Removed a couple of "erroneous" groups and now works fine. Will find out why I needed to remove some groups.
Yes, this was my exact issue as well. Both of the workspace that failed were template apps, but not all template apps failed.
Thought I had filtered all those away. I'll look closer. Thanks!
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.
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
I think your token expires. so you will need to refresh the bearer token part in your "advanced editor" section :)
I need good wen please