Forum Discussion
getting error while setting user as service principle user while using commandlet for Power Bi
From my Power shell I am running the following command and getting the error mentioned below.
Command -
Add-DataGatewayClusterDatasourceUser -GatewayClusterId {cluster_id} -GatewayClusterDatasourceId {datasource Id} -DatasourceUserAccessRight Read -Identifier {AD app object id}
Error -
Add-DataGatewayClusterDatasourceUser: Response status code does not indicate success: 400 (Bad Request)
Request Id: c21f5c3d-5042-4256-9232-bfff3f906b38
Timestamp: 6/8/2024 9:47:26 AM +00:00
ErrorCode: DMTS_UsersNotFoundError
I am using Web as my data source.
Can anyone please help me resolve this issue
AkashJain
I guess it will work if you give the object id of the corresponding external application ID. To find the external application object id of your app registration. Open your app registration from the azure portal and click on the the name of the application next to managed application and there you will find object id.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Hi AkashJain ,
You can refer this -https://www.dataunlock.com.au/how-to-perform-power-bi-on-prem-data-gateway-management-using-service-principal/
Thanks,
Sai Teja
4 Replies
- tharunkumarRTKSuper User
AkashJain
I guess it will work if you give the object id of the corresponding external application ID. To find the external application object id of your app registration. Open your app registration from the azure portal and click on the the name of the application next to managed application and there you will find object id.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
- AkashJainRegular Visitor
Thanks for the help tharunkumarRTK .
I was exploring the ways around and got a very easy and small way to solve this which takes seconds to solve this issue.
The way you are telling is also working.
- AnonymousNot applicable
Hi AkashJain ,
I am glad you have solved the problem. If you do not mind, could you share with us how you solved it to help more people with similar problems in the future.
Best Regards,
Ada Wang
- SaiTejaTalasilaSuper User
Hi AkashJain ,
You can refer this -https://www.dataunlock.com.au/how-to-perform-power-bi-on-prem-data-gateway-management-using-service-principal/
Thanks,
Sai Teja