getting error while setting user as service principle user while using commandlet for Power Bi

[AkashJain]

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

[tharunkumarRTK · Accepted solution]

@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

[AkashJain]

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.

[Anonymous]

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

[SaiTejaTalasila · Accepted solution]

Hi @AkashJain ,

You can refer this -https://www.dataunlock.com.au/how-to-perform-power-bi-on-prem-data-gateway-management-using-service-principa...

Thanks,

Sai Teja 

[tharunkumarRTK · Accepted solution]

@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