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