Forum Discussion

JayHam's avatar
JayHam
New Member
4 years ago

Connect Power Pivot to PBI Dataset

Hi all,

 

We are looking into ways to retrieve data from a Power BI dataset into Power Pivot (data model). Using the standard analyse in Excel route creates pivot table but are wanting the data to be stored in the data model. When connecting to sources from the data model in Excel there is no option to connect to PBI Datasets.

 

Is this possible?

 

Thanks in advance.

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Yes. Instead of connecting to the Power BI dataset you need to connect to the SSAS data source in import mode.  You get the server details from the dataset's "server settings" section.

    • JayHam's avatar
      JayHam
      New Member
      4 years ago

      Thanks lbendlin,


      I'll give that a go and let everyone know the results. I'm not familiar SSAS connection but will do a bit of searching. Thanks!

    • JayHam's avatar
      JayHam
      New Member
      4 years ago

      lbendlin,

       

      I can't see the server settings. Having had a look around this seems to be a premium feature and I'm currently on Pro. Is there any other way to get the server connection string?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        sorry should have asked what license you are on.  You can try the connection string from the Excel query but i haven't gotten that to work yet (no need in my license/capacity situation)