Generating Access Token in Power BI Using Client Credential Flow

Рет қаралды 20,442

Күн бұрын

Пікірлер: 46

@PunyaKP Жыл бұрын

Hi Sir, I was looking for the same. i did lot of searches here and there. however, i did't find anything over the internet from past 5-6 days. now i landed on the correct page. thank you so much.

@AravindBS Жыл бұрын

Thanks

@slozadar 9 ай бұрын

Excelent video, thanks so much.

@AravindBS 9 ай бұрын

Thank you..

@user-fj7im5dz1j Жыл бұрын

It great Video, just let me know if can I implement RLS in the embedded report. Where 1000 users (outside organization we can call clients) and data will get filtered based on the user log-in to that website. (User doesn't have a Microsoft license) which license do I need to purchase? and how?

@AravindBS 9 ай бұрын

See Rls is different story. You need to have list of users list in power bi repo and you need to place rls to check the access for specific user for specific report

@anilkadiri1532 9 ай бұрын

Excellent Video , How to validate post adding the Tentant and APP ID etc ?

@AravindBS 9 ай бұрын

Thank you..

@AravindBS 9 ай бұрын

Could you please let me know what exactly you need to validate?

@quackquack462 2 ай бұрын

when I'm trying to create a function it's showing "The query does not reference any parameters . Are you sure you want to create a function without parameters. can we create the function irrespective of the error or the parameters should be added ?

@AravindBS 2 ай бұрын

Hey Could you please share context of this?

@quackquack462 2 ай бұрын

@@AravindBS I have client id ,Client secret and url , i want to retrive the data from that by raising a acces_token .This is my first time trying this . i have added a function with no error in it , when i try to run it ,it's asking for authentication , but this is not a api-key authentication , i only have access token .

@quackquack462 2 ай бұрын

after creating the access token function ,what is the next step to get the data

@pritichaudhari7596 Жыл бұрын

how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

@AravindBS 7 ай бұрын

You need to add trusted app as power bi in azure ad

@quackquack462 2 ай бұрын

nice work

@ArjunSimon Жыл бұрын

This really helped. Thanks!

@AravindBS Жыл бұрын

Thanks

@krish6454 Жыл бұрын

Aravind, nice explanation. When you create the client Id and secret , is there a way to set token expiration?

@AravindBS Жыл бұрын

Yes. You can set up expiration policy in portal

@krish6454 Жыл бұрын

@@AravindBS Thank you so much for your quick response. Can you please share any video that explains it

@AravindBS Жыл бұрын

Sure. I will make it and upload it

@krish6454 Жыл бұрын

@@AravindBS Once again thank you so much. What I am looking for is To integrate MuleSoft with Power Bi. In this process we need to create an app and register it in azure and link it with power bi and generate Client Id and secret with token expiry Somehow we did the setup but We getting below Access token has expired, resubmit with a new access token'

@AravindBS Жыл бұрын

I can help you on this. I will upload a video on hich explains on creating secret for client id in azure ad

@morinho96 4 ай бұрын

Hello, Correct me if I'm wrong, but it seems like even though at the beggining you said you must use application permissions when using client and secret, it seems like you created delegated permissions ?

@AravindBS 4 ай бұрын

Hello here I am using application level access

@morinho96 4 ай бұрын

@@AravindBS thanks for the quick reply !! and for the resource URL, you need to create one in the "expose api" panel ? thank you

@KarthikArji Жыл бұрын

can we do this without Application ID URL, cz my org dont have anything for that

@AravindBS Жыл бұрын

Hi there should be identification to your attached application with client in azure ad

@shamsv4379 3 ай бұрын

Thanks for the video. Will we have any security issue as we are hardcoding secrete key and ID’s . Whoever have access this file will be able ti get these details.? I am trying to get data from one application API,having same issues, that without hardcoding API key, I couldn’t get this working. Any options please?

@AravindBS 3 ай бұрын

Yes we should avoid storing secrets in file. However you can give least privileges to the user to view reports

@wilsonvargas1914 7 ай бұрын

Hi sir , What type of licensing does Power BI require for this solution?

@AravindBS 7 ай бұрын

Hi You can choose one of the licensing model lrovided here powerbi.microsoft.com/en-us/pricing/

@aparnas8958 8 ай бұрын

How we can integrate powerbi reports using this token in react js

@AravindBS 8 ай бұрын

Hello If I am correct, you can embed power bi report inside the react module. Power bi itself provides the code for it. When power bi launches your report, internally it gets the token which can be used further

@aparnas8958 8 ай бұрын

Thank you . Actually we integrated powerbi with react js , but the issue was with getting the token programatically. This method didn't work for me , when I used both username password and client Id client secret I got the token and reports loaded successfully.for grand type we used ' password'.

@keimux2210 6 ай бұрын

this token expires after a short time , is the a way of setting it up to automatically refresh @@AravindBS

@filipesilva2936 Жыл бұрын

The problem is that a dynamic token does not work once you publish to powerbi service, it wont allow refresh

@AravindBS Жыл бұрын

It should work. You have call that getaccess token method inside your query wherever you need. So every time pbi invoke and get new token

@jonathannavaropaterna1014 6 ай бұрын

@@AravindBSHave you tested this solution in PowerBI Service? It can’t be use a dynamic source to schedule refresh….

@AravindBS 6 ай бұрын

Hi @@jonathannavaropaterna1014 I am not understanding why you can't use it for dynamic resourse. In my case most of them are api and we have enabled scheduled refresh

@jonathannavaropaterna1014 6 ай бұрын

@@AravindBS I have tried your solution and it does not work….error 400. I’m using another method which it works but you can’t refresh in PBI Service. Do you have some example in Github or something? I’m stuck with this and anyone can refresh except you, but I have seen it.

@AravindBS 6 ай бұрын

Error 400 means bad request. There might be payload issue. In the method it's not forming paper payload it seems