Log in to PowerBI Service through Excel 2013 PowerQuery

[BFroc]

Hey everyone,

I'm trying to log into my PowerBI Pro O365 account through Excel 2013 PowerQuery in order to begin creating a Data Catalogue. When attempting to sign in, the service tells me I don't have a license. Is this because we don't have Azure running? I know this can't be done on Prem, but it seems odd because I am a PowerBI Pro user (on the temporary license program from the spring changes). The one thing I'm not entirely certain about is searching the data catalogue feature results in ending up on the Azure site. Do we need to have Azure installed to perform this? I can't even log in to the PowerBI service from PowerQuery though...

Am I missing something?

[v-yuezhe-msft · Accepted solution]

@BFroc,

You don't need to have Azure installed.

Do you use a pro trial account to sign in Power BI under Power Query tab? I get a error message as follows when using a pro trial account to sign in Power BI. Everything works well when I use a pro license account to sign in Power BI, and I can use the data catalogue feature.


Regards,
Lydia

[BFroc]

Hi Lydia,

yes, I'm using a pro trial account. I guess the integration isn't available to trial users.

Thank you!