Forum Discussion

Steffe's avatar
Steffe
Icon for Helper I rankHelper I
5 years ago

Oct 2020 update 2 - Direct Query SQL problem remains

Hi, Just wanted to let you know that the issue described in the thread below is still present after upgrading our report server to the latest build (Version: 1.9.7675.15620 (Build 15.0.1104.300), Re...
Direct Query
Power BI Report Server
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi Steffe ,

 

I have tested with the latest version. But I can't reproduce the issue you encountered.

Is this problem a common problem? Does anyone else meet?

 

 

Best Regards,

Icey

Steffe's avatar
Steffe
Icon for Helper I rankHelper I
5 years ago

Hi Icey 

Thanks for looking into this.

It is strange that it works for you.

How do your environment look like? What type (onprem/azure) and version of SQL are you connecting against?

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Steffe ,

     

    My SQL is SQL Server 2017 Developer and my Windows version is 10.0.19041 Build 19041.

     

    In addition, I have confirmed internally that this bug is being fixed by the product team. This is a known issue that has been submitted internally (ICM#: 21688995). Please be patient and I will let you know if there is an update.😊

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

    • Steffe's avatar
      Steffe
      Icon for Helper I rankHelper I
      5 years ago

      Thanks Icey 

      Then we wait for a fix 🙂

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Steffe ,

         

        The January 2021 release of PBIRS is now available to download. The current PBIRS version is: 1.10.7698.12811 (Build 15.0.1105.194), Released: January 21, 2021. It fixed some bugs:


        Bug fixes

        • Fixed issue with scheduled refresh of Power BI reports with certain models using enhanced model metadata.
        • Fixed issue editing data driven subscriptions in portal.

         

        Please check if it works for your scenario.

         

        Reference: Change log for Power BI Report Server - Power BI | Microsoft Docs

         

         

        Best regards

        Icey

         

        If this post helps, then consider Accepting it as the solution to help other members find it faster.