Connecting PowerQuery with PowerBI

When I try to log into PowerBI from PowerQuery, I get the following error message.  I have PowerBi credentials through O365.  I am an administrator for O365.  Your help appreciated.  David

"Enterprise Features Unavailable.   Your organization no longer has access to enterprise features.  Please log out to access public data"

May 25th, 2015 12:35pm

Hi HaynesIdeate,

Based on your error message, it seems this issue might be caused by the version of Office 365 didnt support Power BI, so the features unavailable.

First I suggest you check the version of your office 365, maybe youre using Office 365 Enterprise E1 which cannot use Power BI features. As shown in the following figure:

After checking the version of your Office 365, this issue also might be caused when you tried to logon Power Query, you clicked the Keep me Sign in button, but the sign in was not successful.

So you can try to log out and log in again. There are two methods to logout:

Method 1:

  1. Clean the cookie
    1. Close all excels and IEs
    2. IE->Setting->General->Delete, uncheck Preserve Favorites WebSite Data and check check Cookies and website data.
    3. Click ok.
  2. Logout Office365

Method 2:

  1. Open excel
  2. Go the PowerQuery tab, and click SignIn button. It should show the login page again.

If you have more questions about Power BI feature in Office365 please post your issue to Office 365 Forum:

https://social.technet.microsoft.com/Forums/en-US/home?category=officeitpro,sharepoint,exchangeserver,lync,project

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Hope its helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2015 4:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics