topic Programatically connecting to power BI premium workspace using workspace url in Developer

Programatically connecting to power BI premium workspace using workspace url

Anonymous — Tue, 23 Nov 2021 07:07:00 GMT

Am trying to connect to a Power BI workspace by using the Workspace Connection URL.

Below is the code:

public static void ConnectToPowerBIAsUser()
{
string workspaceConnection = "powerbi://api.powerbi.com/v1.0/myorg/Superstoresales";
string userId = "test@nousinfo.com";
string password = "********";
string connectStringUser = $"DataSource={workspaceConnection};User ID={userId};Password={password};";
server.Connect(connectStringUser);
}

When i execute the code am getting the below error:

Microsoft.AnalysisServices.ConnectionException: 'The connection string is not valid.'

Inner Exception:

FormatException: Input string was not in a correct format.

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Wed, 24 Nov 2021 08:57:27 GMT

@lbendlin @TedPattison @Anonymous Any inputs for the above query?

Re: Programatically connecting to power BI premium workspace using workspace url

TedPattison — Wed, 24 Nov 2021 12:53:07 GMT

As far as I can tell, the connection string looks fine. Can you confirm that this workspace is associated with a dedicated capacity?

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Wed, 24 Nov 2021 14:29:06 GMT

@TedPattison No workspace is not associated with dedicated capaticy.

Premium per user is enabled for the workspace.

Do we require premium capacity to perform data refresh?

Re: Programatically connecting to power BI premium workspace using workspace url

lbendlin — Wed, 24 Nov 2021 14:58:53 GMT

The documentation doesn't mention anything explicitly but I wouldn't be surprised if there were API limitations too

Power BI Premium Per User - Power BI | Microsoft Docs

Re: Programatically connecting to power BI premium workspace using workspace url

TedPattison — Wed, 24 Nov 2021 16:12:26 GMT

Can you confirm your user ID is for a user with a Power BI Premium per User license.

Did you copy the URL from workspace setting to ensure it matches

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Wed, 24 Nov 2021 17:07:16 GMT

Am having Premium Per User license.

Please find the below screenshot for reference.

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Wed, 24 Nov 2021 17:13:25 GMT

I tried with Username, Password and with Access token as well.

But am getting the same error in both cases.

Re: Programatically connecting to power BI premium workspace using workspace url

TedPattison — Wed, 24 Nov 2021 17:58:28 GMT

OK, one more thing to check. The Capacity administrator has the ability to set the XMLA endpoint to Off, Read Only or Read Write. If it is set to Off, the behavior you are seeing is expected. Are you able to check the XMLA Endpoint setting in Capacity Settings in the Power BI Admin portal as shown in this screenshot? If you don't have Capacity Admin permissions, you will need to find someonbody who does.

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Thu, 25 Nov 2021 06:32:10 GMT

Do capacity settings will be available for premium per user account?

When am checking admin portal capacity settings are not available for my premium per user account.

Re: Programatically connecting to power BI premium workspace using workspace url

Anonymous — Thu, 25 Nov 2021 12:32:02 GMT

HI @TedPattison

I have eneabled XMLA Endpoint for ReadWrite and when i try to execute the above code am again getting the same error.

Could you please provide your inputs?

Re: Programatically connecting to power BI premium workspace using workspace url

TedPattison — Mon, 29 Nov 2021 13:55:08 GMT

I have given you all the ideas I have about what the problem might be and how to troubleshoot it. I cannot think of anything else that might be wrong. I think at this point, you should contact Microsoft support who can captire more diagnositc info that might help to troubleshoot this.

Re: Programatically connecting to power BI premium workspace using workspace url

ozhug — Mon, 15 Jan 2024 05:40:30 GMT

The key here is using the correct libraries

counter-intuitively do not use the Microsoft.AnalysisServices.Tabular library
you need to use these libraries based on your code base.
For .NET Core we need to install those two libraries:

Microsoft.AnalysisServices.NetCore.retail.amd64

Microsoft.AnalysisServices.AdomdClient.NetCore.retail.amd64

For .NET Framework those two libraries:

Microsoft.AnalysisServices.retail.amd64

Microsoft.AnalysisServices.AdomdClient.retail.amd64