Forum Discussion

Erikvbueren's avatar
Erikvbueren
Helper I
11 years ago

Power Query Sign in error

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.

10 Replies

Replies have been turned off for this discussion
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      konstantinos
      Memorable Member

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

      • Anonymous's avatar
        Anonymous
        Not applicable

        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.

  • 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:

    Excel Power Query Issue.jpg

    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:

    Power BI Login Error.jpg

     

    I close that window and get this:

    Power Query Enterprise Features.jpg

     

    I am then back to where I started from!

     

    I cannot figure out how to get past this issue!  >:-( 

     

    Appreciate any assistance!  Thanks

    • kstinnett's avatar
      kstinnett
      New Member

      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's avatar
        sergeroz
        New Member

        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?

  • zootsuitryan's avatar
    zootsuitryan
    Frequent Visitor

    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