ExecuteReader requires an open and available connection error

mq 1 Reputation point
2021-03-15T11:38:32.073+00:00

Why do I get this error message when consuming a table? and how can i fix it?

77787-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,000 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-03-16T07:47:34.083+00:00

    Hi,

    A little background would help us to narrow down and do proper research on this, what were you trying at the time ?

    It looks like a connectivity issue to me, what is your datasource?