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 find any tabular model-dataset (live connection to model). I find only datasets that connects to SQL Server database. How can I make tabular model-datasets visible in Excel?

 

 

 

 

 

 

Need Help

6 Replies

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