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-bb80b4a54c04TimeThu Jan 24 2019 12:48:25 GMT + 0300 (GMT + 03: 00)Version 15.0.1102.222 Regards.

We have identified the issue here with Direct Query reports when using Basic Authentication and team is working on a fix. We expect to release it in next few days. Apologies for this miss.

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

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

Update has been released and it has resolved the direct query issue. Thanks Power BI team.

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.

PowerBi update 2019 January Direct Query Error!!!!

39 Replies

mgmeyer
Power BI Team
7 years ago
Thanks for reporting this, we'll investigate and update you shortly.
- Anonymous
  Not applicable
  7 years ago
  We are having exactly the same issue. Hopefully there is an easy fix soon. Please keep us updated.
- andrewpasquetti
  New Member
  7 years ago
  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.
  
  Thanks
  - Anonymous
    Not applicable
    7 years ago
    We have the same issue. The impact is severe.
    Is any update forthcoming?
andrewpasquetti
New Member
7 years ago
Update has been released and it has resolved the direct query issue. Thanks Power BI team.
- jrosalesgo
  Frequent Visitor
  7 years ago
  BasicAuth with Direct query for external sources is working again, Thanks so much.
- Anonymous
  Not applicable
  7 years ago
  Thank you guys!
Anonymous
Not applicable
7 years ago
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.
Anonymous
Not applicable
7 years ago
By the way we sure that the all of our connection strings are true.

Thanks.
- Anonymous
  Not applicable
  7 years ago
  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.
  - Anonymous
    Not applicable
    7 years ago
    Completely the same steps and errors. I hope it will be solved as soon as possible.
Anonymous
Not applicable
7 years ago
Our Directquery reports fail, since we installed the updates.
- vvnck
  Frequent Visitor
  7 years ago
  If your data direct query from SQL Server, the auth must use windows auth. if use basic auth will error.
  - Anonymous
    Not applicable
    7 years ago
    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.
jrosalesgo
Frequent Visitor
7 years ago
But what happen when you are not able to change the way to login, I have the same report on Power BI Report Server Aug 2018 and Jan 2019 on Aug 2018 works fine and on Jan 2019 is not working at all, same server, bd, and credentials.
- rpatkar
  Power BI Team
  7 years ago
  We have identified the issue here with Direct Query reports when using Basic Authentication and team is working on a fix. We expect to release it in next few days.
  
  Apologies for this miss.
  - Anonymous
    Not applicable
    7 years ago
    Thank you for your work guys!
Anonymous
Not applicable
7 years ago
Hello,

We have upgraded to the latest version with the bug fix, but we are still getting the error. In our case we have the Power BI report connected to a Hana source with Direct Query Mode, and basic authentication.

Thank you!

Kind regards,

Julieta.
- rpatkar
  Power BI Team
  7 years ago
  hi Julieta,
  
  Team has identified a bug here and we are working on fixing it. You can expect the fix to be released in the next few days. Thanks for reporting the issue.
  - Anonymous
    Not applicable
    7 years ago
    Thank you very much for the reply! Could you please inform once you have released the latest update? We are trying a workaround in the meantime .
    
    Kind regards,
    
    Julieta.