Forum Discussion
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:
I used to have this open available but no longer see it an option in the drop down. Just curious to see if something has changed, is no longer supported, or maybe I need to update something on my end. I did just reinsall the analyze for excel component but not seeing any changes in excel from that update.
I have an existing excel file that I'd like to bring some data from a dataset into and was hoping to bring it in this way. On a side now I am able to download the .odc file and open that. Is there another way to create that connection in an existing excel file so I can bring the data in?
Thoughts? I am a pro user.
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
10 Replies
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
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.
No, that's not what I mean.