Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
5 years ago

This error message shows up quite often when working with composite models connected to 2 datasets in power bi desktop - 'OLE DB or ODBC error. The session ID cannot be found. Either the session does not exist or it has already expired.. Is this to be expected, or is there a workaround? The datasets use a combination of DQ and import (but prominently DQ)

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    this is not expected - please open an issue on issues.powerbi.com

  • mamsteroonie's avatar
    mamsteroonie
    Icon for Helper I rankHelper I
    4 years ago

    I find if you go to transform data, data source settings, and add another table to the composite data source, it refreshes the session and you can continue working in it (just delete the table you added).