How to connect to PowerBI.com

DaxStudio / DaxStudio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Desktop, Power Pivot for Excel, and Analysis Services Tabular.

http://daxstudio.org

Other

689 stars 143 forks source link

How to connect to PowerBI.com #133

Closed fmms closed 5 years ago

fmms commented 5 years ago

Hi,

to my understanding the 2.8.0 supports to connect to a PowerBI.com workspace. In the source I have seen powerbi:// as adress for that.

How do i find the connection string for my PowerBI.com dataset?

Having the nice connection dialog #126 would be cool, but is just the second step ;)

regards

dgosbell commented 5 years ago

You currently have to be part of the preview program in order to have this ability enabled on your PowerBI Premium capacity. If you are in the preview you can find details of how to connect in the associated Yammer group. I don't think the uri format is a secret, but I'm not sure if it might change before the public release.

dgosbell commented 5 years ago

Apparently the uri format has been announced somewhere and it uses the following format: powerbi://api.powerbi.com/v1.0/[your domain]/[your workspace name]

Where:

your domain is the domain for your tenant
your workspace is the case sensitive name of your workspace

So in some of the microsoft demos you will see people connecting to endpoints like: powerbi://api.powerbi.com/v1.0/**microsoft.com**/**Demo Workspace**

When you attempt to connect to an endpoint like this the Adomd provider used by DAX Studio will prompt you for your Power BI credentials and will then connect you to the first dataset it finds. You can then select other datasets in that workspace from the database dropdown in DAX Studio.

fmms commented 5 years ago

ok, i have tried this with my Power BI premium workspace an get the following: When entering a "/" at the end of the URL it says "workspace does not exist".

So this what is expected when that workspace is not part of the preview? Where can I register for that preview?

regards

dgosbell commented 5 years ago

Yes, that is what you would expect if you are not part of the preview.

As far as I am aware this feature is still in a private preview phase (so invite only at the moment). According to this page they are aiming for a public preview next month.