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
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.