Forum Discussion

Skyter's avatar
Skyter
Regular Visitor
8 years ago

Analyze in Excel

Hello, 

2 days ago we had no problem, but now we can't access PBI data in Excel. All users are BPI Pro, settings in PBI Portal is OK.

6 Replies

  • Skyter's avatar
    Skyter
    Regular Visitor

    Hello, 

    2 days ago we had no problem, but now we can't access PBI data in Excel. All users are BPI Pro, settings in PBI Portal is OK.

  • I am experiencing this same issue. I am unable to connect to my reports or datasets through the Excel Power Bi tab.

  • Skyter's avatar
    Skyter
    Regular Visitor

    It seems to me that problem is in Excel 2016, cause i've just connected from one of my computers with Excel 2013. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Skyter,

     

    Based on my test, I could connect to Power BI service from Excel 2016 sucessfully.

     

    As mentioned in error message, please check whether the dataset you choose exists and whether you have access to the selected dataset.

     

    1. Data that has been shared with you, but isn't directly visible to you in Power BI, is not available in Connect to Data.
    2. Datasets shared with people outside the specified group are not supported, and cannot be connected to.
    3. Reports or datasets that were shared with you cannot be connected to.

     

    Reference: connect to Power BI data in Excel

     

    Best regards,
    Yuliana Gu

    • Skyter's avatar
      Skyter
      Regular Visitor

      I'm sorry, but i've mentioned that:

      1.  3 days ago it was OK: It has DataModel, i'm administrator of this data and we've tried everything according to help
      2. I can access this data from one of my computers

      So it looks like a bug in a system

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee

        Hi Skyter,

         

        Please try to sign out and sign in again in Excel to see whether it resolves problem. Besides, if you click the "Analysize in Excel" on Power BI service, can you view dataset data successfully in Excel?

         

        Regards,
        Yuliana Gu