Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ODC Connection Session ID for Analyze in Excel

I have a dataset published to the Service. Using Analyze in Excel to create pivot tables. Many times when I try to refresh the connection, I get a "Session ID cannot be found. Either the session does...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Tough to do, being that the Power BI Publisher for Excel has been retired. In Excel, I don't see any option to get data from a Power BI dataset.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

If you are running one of the newer versions of Excel you can do it by clickong on Data, then Get Data then Power BI as shown below