Power Query Sign in error

[Erikvbueren]

I try to connect from Excel 2013 to my shared Data Sources on PowerBi.com

After Signing in I Receive the following error:

Enterprise Features Unavailable: Your Organization no longer has access to enterprise features. Please log-out to access public data.

I do have access (and licensed) to PowerBi.Com and I can create reports with Power BI for Desktop, but I would use Excel for Power Query or Power Pivot Excel Reports.

[zootsuitryan]

I am also having this issue when trying to access sign in to Power BI through Power Query in Excel 2016 (Get & Transform).

Has anyone found a solution to this problem?

Thanks,

Ryan

[BenHoward]

Please see this posting...  https://social.technet.microsoft.com/Forums/en-US/2157c82e-0e72-4e98-be24-b7a3eb815249/enterprise-fe... which might hold a solution

[Scooterza]

I am experiencing a similar problem.  I am using Excel 2013 Professional Plus.  I have also downloaded and installed the Microsoft Power BI Desktop.  When I open Excel, and look at the Power Query Tab, the options to get data are greyed out:

If I try to Sign In using the icon on the right and I use the same login credentials as I use to login to the Power BI web dashboard, I get an error as follows:

I close that window and get this:

I am then back to where I started from!

I cannot figure out how to get past this issue!  😠 

Appreciate any assistance!  Thanks

[kstinnett]

I am having the same issue. I know we have Office 365 E3. I cant seem to find anyone that can resolve this problem

[sergeroz]

I am having the same issue. We have Office 365 Enterprise E3 licence.

I have Office Excel 2013 with Power Query Version: 2.26.4128.242 installed.

Has anyone been able to resolve this issue?

[BenHoward]

I also have the same issue, from Excel 2010, 2013 and 2016 when I either try to sign into Power BI from the Power Query ribbon, or Save query to Data Catalog from Excel 2016.  I've even tried this on a couple of different PCs, and a couple of different tenants.  Does this feature actually work anymore?

[Anonymous]

Well I have the exact same problem. In short. How do I share a query from Power Query in Excel ? Is it possible at all when using the new Power BI? Or do I need to have an old Power BI for Office 365? It's not very clear. I am not able to sign in at all from Excel getting various strange errors.

Can someone please clarify?

[konstantinos]

You cannot share a query with PowerBI V2 ( new )..Only in PowerBI for O365 (old )..

[Anonymous]

Thank you for your reply. So now i actually created a new Office 365 trial version so I could use the "old" Power BI for demo purposes. Seems like I can only get a Power BI Pro trial though. This makes it possible to actually save and share a query from Power Query in Excel.. But is it correct that it is not possible to create a Power BI Site in SharePoint anymore? Power BI does not appear in my site content in SharePoint. TIA.

[Greg_Deckler]

I'm wondering if you still have a SharePoint Online Plan 2 license (Enterprise), just wondering if that is still needed like it is on Power BI for O365. Can you check your admin center in O365 and see if any licenses recently expired?