We updated the Power BI Report Server with Jan'19 version and we are taking the direct query error. The reports open the Power BI Desktop (January 2019) with no issue. After we save as the Power BI report server, the reports don't open and below error code. Can you help me please?
An unexpected error has occurred. Please try again later.
Please try again or contact the support team.
If you contact the support team, please provide the following information.
We could not connect to the Analysis Services server.
Make sure that you have entered the connection string correctly.
TimeThu Jan 24 2019 12:48:25 GMT + 0300 (GMT + 03: 00)
I'm seeing the exact same issue. Local desktop reports work fine. The same report running in the Power BI Report Server service fails to connect when there is a Direct Query configuration. Any report that has Imported Data, works OK.
I've patched SQL 2016 with the latest CU 5 update, but the problem still exists. Hope the Power BI Team can release a fix for this as soon as possible.
Yes, that's an important point. We also checked our connection strings. Once the report has been published, I have re-entered the username and password for the connection, and tested it before saving. All worked well. However, loaded the Direct Query report, still fails.
Has there been any response from the development team as yet?
It is quite urgent as all of our existing direct query reports on our PBRS are now broken.