Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Using Get-DataGatewayClusterDataSource in Powershell with Service Principal

Hi everyone !

 

I'm working on a project where we try to automatize the Gateways informations gathering. Make it non interactive.

For now, I successfully connnected to the service with the Connect-DataGatewayServiceAccount cmdlet with a SPN

 

Now my problem is when I try to get the Datasources in each cluster with the Get-DataGatewayClusterDataSource cmdlet, the result is empty and the following error returns :

 

>> TerminatingError(Get-DataGatewayClusterDatasource): "This cmdlet does not currently support service principals."

 

Do you know if ther's any workaround for this ? Because if we try to connect to the Gateways with a regular account, a first-party application pops for connecting the account, and it doesn't fit our need

 

Thanks in advance for any piece of advice !

2 REPLIES 2
RakeshSinghr
Resolver I
Resolver I

As it currently stands, using gateway commandlets with SPN is not possible.

 

You can only call them with an account having PBI Admin role

Anonymous
Not applicable

Hey @RakeshSinghr , thanks for your reply !

 

But then why does Connect-DatagatewayServiceAccount allows SPN ? Is there a chance that gateway cmdlets will be used with SPN in the future ?

Also, is there a workaround for this (Call an API ? Something else ? ) or to at least avoid the authentication window when connecting ?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.