Forum Discussion

mturcotte_epq's avatar
mturcotte_epq
Advocate I
7 years ago

Couldn't connect Unsupported keyword

Since we upgraded PBIRS (from August 2018 to May 2019), we are experiencing problems with new PBI reports (either published/saved as on Report Server or Uploaded from PBIRS Portal) not able to connect to a SQL Server 2012 Data Source that other reports have no problem with.

"Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
Keyword not supported: 'eppv-sql12-2c\epqdw_prod;warehouse;integrated security'."

 

The odd thing is we are using the same data source configuration details as in other reports that Test the connection just fine on the same data source.

 

Any help appreciated.

 

MT

Data Source Error

10 Replies

    • d_gosbell's avatar
      d_gosbell
      Super User
      7 years ago

      Your connection string does not look to be complete (although I'm not sure how the test is working)

       

      If you try the following format does it work?

       

      Data Source=eppv-sql12-2c\epqdw_prod;Initial Catalog=WAREHOUSE
      • mturcotte_epq's avatar
        mturcotte_epq
        Advocate I
        7 years ago

        Thank you for your reply.

        Actually, the connection string in the screenshot at the bottom is from the report that works fine and whose Test Connection also works. Yet, it is the same connection string as I have in the Report that experiences the error, but the portal Data Source configuration interface does not allow me to edit it (i.e it was apparently set by the Desktop upon publishing).

         

        Any other ideas?

         

        Thanks again!

         

        MT

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Problem experienced here too.. Please fix Microsoft!