Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 th...
PBI Report Server Jan'19 Update
jrosalesgo's avatar
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's avatar
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's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you for your work guys!

  • mpsrshl's avatar
    mpsrshl
    Advocate II
    7 years ago

    Hey, when will you fix this plus cross filtering? two major screw-ups from this update.

    • rpatkar's avatar
      rpatkar
      Power BI Team
      7 years ago

      hi,

       

      We are getting ready to ship the fix for the DQ-Basic Auth issue. What is the cross filtering issue you are referring about? If there a community thread about that issue or can you please share more details about it?

       

      Thanks,

      Rohit

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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?

  • mahias's avatar
    mahias
    Frequent Visitor
    7 years ago

    Dear,
    I am writing from Chile, to tell you that we are using Power BI Report Server Version 1.4.7024.16477 (January 2019) to connect with Oracle, we are also using a direct query and basic authentication. And when trying to visualize the report through the web portal of Power BI, the system shows us the following message:

     

    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.
    Application identifier b6b669e1-2b5d-2321-00c2-a69b129374db
    HoraTue Apr 30 2019 10:32:04 GMT-0400 (Chile standard time)
    Version 15.0.1102.299

     

    regards

    Eduardo

    • mpsrshl's avatar
      mpsrshl
      Advocate II
      7 years ago

      Hi compatriota,

       

      Are you using a direct query to a data source and imported data to another one in your data model? 

       

      if this is the case: 

      PBIRS does not allow the module you have setup in your dashboard. Direct query and Imported data is a dual feature (Composite Models) it only exists in the cloud service for now. If you want to make it work, you will have to turn all data streams into "import mode" and then set scheduler on the properties of the dashboard inside the Report Server "Manage" section. 

       

      If all your data is imported into the PBI file: Re-enter the credentials inside the PBI file by deleting your connection strings and re adding them in lowercase (Servername/InstanceName). Upload PBI file back to the Report Server and see if it works. 

       

      Hope it helps. 

       

      Marce

      • mahias's avatar
        mahias
        Frequent Visitor
        7 years ago

        Good afternoon marce

        Thanks for answering my question, you have an email to contact you.

        regards

        Eduardo

         

        Buenas Tardes Marce

        Gracias por responder a mi consulta, tienes algún email para poder contactarte.

        Saludos

        Eduardo