Dear Community,
We have recently had some issues with some previously published PowerBI Reports that connect to SAP HANA
Almost a year ago, we published the first version of a set of reports from HANA to powerbi.com. At some point over the Christmas period (or shortly before) any visualisation that had an 'is' filter set on it stopped working. Whenever the reports were loaded, these visualisations would display "Cannot display this visualisation" with an error at the top stating to contact the gateway administrator. No changes have been made to these reports for approx 3 months, and we know that they were functioning early December, however due to the Christmas break and other priorities in the business, we're not able to nail down exactly when these issues started occuring.
As I was not able to replicate the issue on my machine, I through trial and error discovered that the pre-set filters were causing the issues that users were experiencing using the web interface. Filters on the query don't cause a problem, and neither do 'IS NOT' or 'Contains' filters, so I replaced all our pre-set filters with a combination of these. However once these were all published to PowerBI.com, we found that any filters applied using slicers resulted in the same error.
The next step taken was upgrading the PowerBI Desktop client on my machine, believing that a mismatch between the service and the client version could cause issues with filters. Unfortunately this has now meant that I get the same issue on my machine when maintaining the reports (makes troubleshooting slightly easier, but doesn't resolve the problem)
Has anyone experienced similar issues and resolved them? If so, what was the resolution?
Thanks in advance,
Kieran Magill
