Forum Discussion

tuulia's avatar
tuulia
Icon for Helper IV rankHelper IV
4 years ago

PowerBI datasets in Excel

Hi! I am trying to "import" Power BI dataset to Excel (Get data -> From Power BI). This dataset is published to PowerBI.com to my workspace. When I open Excel and try to find this dataset I can't fin...
Need Help
Burningsuit's avatar
Burningsuit
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Hi tuulia 

This may be because you don't have read access to the data in Analysis Services. 

From the documentation...

Connecting to Power BI datasets that are built on live connections to Analysis Services is not supported unless the user has read access to the data in Analysis Services in addition to the datasets permissions in Power BI.

 

See: Troubleshoot connecting Excel to Power BI data - Power BI | Microsoft Docs

 

Hope this helps

Stuart

  • tuulia's avatar
    tuulia
    Icon for Helper IV rankHelper IV
    4 years ago

    I have Full Control (administrator) role to every model..

    • v-kkf-msft's avatar
      v-kkf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi tuulia ,

       

      Could you use the "Analyze in Excel" function for the dataset directly on Service?

       


      Or if you have the connection file for this dataset, you can open it in the data source settings.

       

           

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

      Best Regards,
      Winniz

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

      • tuulia's avatar
        tuulia
        Icon for Helper IV rankHelper IV
        4 years ago

        Hi! This is weird, I can't use "Analyze in Excel" function anymore. This function opens an Excel workbook, but there are no tabular mobel to browse. I am an owner of all datasets and I have "full control" role in every tabular model.

         

        When I open Excel and make connection to model (get data -> from database -> from analysis services) everything works fine