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

Hi,

I am used of connecting to Power bi from Excel and realized that since the May 2020 release of Power BI desktop I cannot connect to data using the power bi tab, and do not see the connect to power bi dataset option. Have those options been removed?

Please let me know