Forum Discussion
Connecting to dataverse from PowerBI using client id , client secret
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.
Maybe you can create a dataflow in power bi service to connect to Dataverse:
Then you can use service principal to authenticate:
So that you can get data from dataflow in power bi desktop:
Here for your reference:
Create your first Microsoft Fabric dataflow - Microsoft Fabric | Microsoft Learn
Creating a dataflow - Power BI | Microsoft Learn
Hope it helps.
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.
Anonymous Hi thank you for suggesting this when I tried approaching in the dataflow it says invalid credentials should I need a also configure a gateway for this? Will that help ?
bcoz my cress are right !
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.Hey Anonymous thanks for this, it worked but when I import the dataflows to local desktop the tables are empty!
Please check if there are any data in your dataflow.
After you've created your dataflow, you'll need to wait for it to refresh before you can connect.
In general, this may continue for a while
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.