Forum Discussion
Harineeeeeeee
Helper I
Helper IConnecting to dataverse from PowerBI using client id , client secret
Hi , I am trying to connect to dataverse from PowerBI, I have only this info tenant id, client id, client secret and env url based on the info I have wrote a power query as below, but this is not...
You need to add the App registrations to the Security group and add the security to the Dataverse environment, so that you can use the security principal to authenticate.
Here for your reference:
Control user access to environments: security groups and licenses - Power Platform | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super UserWhy not use the standard connector?
HarineeeeeeeeHi lbendlin the standard connector allows only organisational account as credentials I don't have option to tie out with service account , also I have this info client id, client name , tenant id and client secret