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
6 years ago

How do I create that connection in excel? From the Get Data standpoint which option do you select? I can see the connection info in the properties of the odc file that is download, just unsure of how to take those connection properties and create a similar connection in an existing excel file. 

 

I did just do this and it works, maybe this is what you were refering to and this should sufice.

Data (Tab) - > Existing Connections -> Browse for More... -> Select your .odc file

 

However, I would still like to know why the option under Get Data is missing the Power BI Dataset. 

 

lbendlin's avatar
lbendlin
Super User
6 years ago

No, that's not what I mean.

 
  • Genty's avatar
    Genty
    New Member
    4 years ago

    Hi,

    I have the same problem with O365 E3 and PowerBi Pro license. Any suggest?

    Thanks a lot