Forum Discussion
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.
setup: SQl Azure (data warehouse), Direct Query (table)
Filter is on a data field that is not on the report.
Data visualization is table or matrix. Filter was original Slicer but also fails with report filter.
- 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.
- message: Can't display the Visual / Couldn't load the data for this visual.
This behaviour is since few days in the service and in the desktop version after installing the januari 2018 update.
as a temporary workaround i added the field being filtered on to the report and the filter works again.
..but i don't want to show the field on the report..
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! ;-)
10 Replies
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've got a similar issue. With the new version, I'm not getting the slicers to appear as more than ghost boxes in the Power BI Desktop client. I'm connected up to a data-cube in analysis services. I didn't bother trying to publish the report. I reverted to the last release to continue working, hopefully sombody over at Microsoft will have a harder look at this and get it sorted out before the next release. This is a pretty major problem.
I found a link for reporting a ticket and submitted my issue. There was a moderator response.
Link for the Issue forum.
Hope that helps!
Todd
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! ;-)
