Share via

ExecuteReader requires an open and available connection error

mq 6 Reputation points
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,280 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 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?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.