Forum Discussion

mpesara's avatar
mpesara
Helper I
8 years ago
Solved

Power BI report server configuration issue

Trying to configure report server to use database engine form sql server 2017 express and eval . Throws the following error "The Database engine instance you selected is not valid for this editio...
  • mgmeyer's avatar
    mgmeyer
    8 years ago

    If your using a Power BI Premium Key to install your report server you can only connect to paid SKUs of SQL Server DB which would be Standard and above; express, developer and eval are not supported.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

You must use a SQL Server standard edition or higher. The report server needs a SQL Server agent,  and a express doesn't has this feature.  On a Report Server without Power Bi is an deployment on a express edition possible. The documentation in on this point not very clear and helpful. 

mpesara's avatar
mpesara
Helper I
8 years ago

I installed standered edition eval to test and developer editon as well, both has SQL server agent , up and running  . But i still get the same error

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Are you really sure that you connect with the configuration manager against the developer/standard edition?

    • mpesara's avatar
      mpesara
      Helper I
      8 years ago

      yes,first am connecting via sql server managment studio and using the same serve name to connect in the powerbi configuration manager

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Can you please post a screenshot from SSMS Server properties?