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! ;-)

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

     

    • tdewittorion's avatar
      tdewittorion
      Frequent Visitor
      8 years ago

      Just wondering if anyone else is having this issue.

       

      I reinstalled the Desktop using the most recent version and republished without success.

       

      Only affecting the Online version.  Desktop works fine.

  • MartinSch's avatar
    MartinSch
    Frequent Visitor
    8 years ago

    maximus12 what if you update to januari 2018 desktop version? if the report then fails i hope it is considered a confirmed bug..

     

    @tdewittorion and others - if somebody can recreate the bug would be very appreceated. also if somebody else has the same setup working just fine.. (online and desktop januari 2018)

     

    setup:

    SQl Azure (data warehouse), Direct Query (table)

    problem with filter on a field that is not in the report

    Data visualization table or matrix.  Data filter is Slicer visualization (original) or report filter (also fails)

    - with no value selected in the filter data shows o.k., if a value is selected in the filter the report fails to retrieve data.

     

    ..and yes, there is data in the source matching the filter criteria ;-)

     

    • tdewittorion's avatar
      tdewittorion
      Frequent Visitor
      8 years ago

      MartinSch, I can recreate your issue in Chrome.  Multiple users in my organization.  AZURE with January installs.  For filters, I had items selected, unselected, could not reselect.  No issue with data retrieval.