Forum Discussion

kjendro's avatar
kjendro
Frequent Visitor
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
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi kjendro 


This could happen because when you upload the PBIX it actually replaces the model, which would mean it has to re-authenticate.

 

In Excel there might be a setting to share the connection?

 

What happens if you connect to your dataset via Excel instead of Analyze in Excel? This might work better

kjendro's avatar
kjendro
Frequent Visitor
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 kjendro 

     

    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