Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Analyze in Excel Via Get Data From Power BI Dataset

I'm trying to analyzie power bi datasets in excel but I'd like to make the connection from Get Data -> From Power BI Dataset as shown here: https://docs.microsoft.com/en-us/power-bi/collaborate-shar...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    The .ODC file creates an XMLA endpoint client connection.

     

    If you want an alternative you can connect from Excel to the "Analysis Services" instance of your Power BI dataset.  There are some subtle differences, but mostly you'll get the same result as with the .odc

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have the same problem - In Excel: I can see how to create a Pivot based on a Power BI Dataset but can;t see how to create a query based on a Power BI Dataset?

 

lbendlin's avatar
lbendlin
Super User
4 years ago

As I indicated you connect to the Analysis Services data source (in import mode) and specify your own DAX query to be run.  In this case I chose EVALUATE DATES

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Ibendlin.  If I click Analysis Services then I'm prompted for a Server and Database.  I don't know how I would find out what those are.  Do you know how I would find that out? 

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      The server and database fields need the connection string from your dataset properties

       

       

       

      server:  powerbi://api.powerbi.com/v1.0/myorg/<workspace name>

      database: <dataset name>

       

      Good luck when you have situations with multiple workspaces or datasets with the same name...

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks Ibendlin,  I'll have a go next week 🙂