Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

PowerBi update 2019 January Direct Query Error!!!!

Hi all,


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.
Request ID2adcd766-b9e7-5a79-431e-bb80b4a54c04
TimeThu Jan 24 2019 12:48:25 GMT + 0300 (GMT + 03: 00)
Version 15.0.1102.222




Yes, you need to download the PBIRS file from the download site and it will do an upgrade of the existing installation.




Thanks a lot for the prompt reply, from what I can read cross filtering has been fixed as well. Is there a place with a list of all what you've fixed on this release?  



Thanks for confirming. Glad the issue is resolved now.
Not applicable

We are using Oracle and direct query so integrated windows auth is not really an option.


Is there an approximate timeline for the authentication fix?

Not applicable

Thank you for your work guys!

Not applicable

Our Directquery reports fail, since we installed the updates.




If your data direct query from SQL Server, the auth must use windows auth. if use basic auth will error.


Thank you @vvnck, using Windows authentication rather than basic authentication worked for my issue.  I'd still like to see the issue fixed, but this is good workaround in my case.  Thanks for posting.

Not applicable

Thank you! I changed the authentication method to an active directory user, with the necessary rights, to try out and it worked.

Is this common knowledge, that you should not use basic authentication with reports using directquery, or is this something new?

Not applicable

Must be somehting new as we use SQL logins on some of our direct query reports

Power BI Team
Power BI Team

Thanks for reporting this, we'll investigate and update you shortly.

Hi All,


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.





We have the same issue. The impact is severe.

Is any update forthcoming?

Not applicable

We are having exactly the same issue.  Hopefully there is an easy fix soon.  Please keep us updated.

Not applicable

By the way we sure that the all of our connection strings are true.



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.

Not applicable

Completely the same steps and errors. I hope it will be solved as soon as possible.

Advocate II
Advocate II

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.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors