cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to access PowerBi from Excel Power Query

When I try to connect to my PowerBI account (where I have my tabular model deployed) I keep getting this message. Anyone know why?

PowerBiErrors.gif

3 REPLIES 3
Highlighted
Power Participant
Power Participant

Re: How to access PowerBi from Excel Power Query

You don't have a Power BI add on license for your Office 365 tenant. The preview access doesn't give you Data Catalog feature
Highlighted
New Member

Re: How to access PowerBi from Excel Power Query

Can you check the status from your O365 Admin Center to check whether Power BI subscription is valid.

SQL Server MVP
Follow: @SQLMASTER
Knowledge sharing network - www.sqlserver-qa.net
Highlighted
Power Participant
Power Participant

Re: How to access PowerBi from Excel Power Query

To clarify my answer above, you need a paid version of Power Bi, not a free one to access Data Catalog.  So if you don't have one you need to buy one and the associate it with your user account in Office 365 admin page.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021