Forum Discussion

MartinSch's avatar
MartinSch
Frequent Visitor
8 years ago
Solved

Problem with filtered report since January 2018 update

We are using a Power BI direct query report with filters. it worked until the januari 2018 update. Now when applying a report level filter, the report doesn't return data and returns an error.   ...
Need Help
  • MartinSch's avatar
    MartinSch
    8 years ago

    tdewittorion Sure helps, thx. Found other similar issues on directquery problems too. Hope for a quick solution.

     

    edit:

    installing new Power BI desktop version 2.54.4970.961 as suggested for your ticket solved my problem! ;-)

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi MartinSch,

 

I was not able to replicate the same problem as yours. Below is the result in my test, my desktop version is January 2018.

 

Filter in desktop.

 

Filter in service.

 

What is your data source type? Could you filter data successfully in desktop? Have you tried to re-publish .pbix file to service for a test?

 

Regards,

Yuliana Gu

  • MartinSch's avatar
    MartinSch
    Frequent Visitor
    8 years ago

    Hi Yuliana Gu,

     

    source is SQL data warehouse, with direct query on one table. republished several times.

    i recreated the report completely and tested in desktop nov 2017 and jan 2018 versions with a subset of the table.

    Nov 2017 version shows data, in jan 2018 version it does not with the filter active. 

     

    First i hoped the visualization type was the cause (selecting the grid in designer did not select a visualization) but the behaviour remains with new selected. so for now i am still stuck...

     

    regards, Martin

     

     

    desktop nov 2017 with filterdesktop jan 2018 versiondesktop jan 2018 after removing filter

    • maximus12's avatar
      maximus12
      Frequent Visitor
      8 years ago

      I have noticed this too!  

       

      SQL Azure, Direct query.  Works fine on desktop (december 2017 version).  Very inconsistent on service (sometimes works, sometimes doesn't).

       

      How can this be raised as a confirmed bug?

      • tdewittorion's avatar
        tdewittorion
        Frequent Visitor
        8 years ago

        I am having a similar issue as well.

         

        Google Chrome:

        Cannot select Slicers in reports.  The Slicers act as if they are locked.  Dropdowns populate with data, but check boxes are unaccessible.

        Filters initially worked when entering a report.  After a few clicks, the filters stopped working.  Every once in a while, a single option will select/deselect.  However, not with any frequency and after a considerable amount of clicks.

         

        Microsoft Edge:

        Both filters and Slicers work correctly.

         

        Thanks!

         

        Todd