Forum Discussion
Problem with filtered report since January 2018 update
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! ;-)
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
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
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?
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
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.
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 ;-)
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.
