I have a report created in PBI Desktop using Direct Query Connection and 1 slicer applied with parameter on date to filter out data dynamically on the report,including date slicer there are other dimensions which are usual slicers created out of tables retreived by import mode.Most of the time,Data displays on the Report in Desktop until unless it has more data to display 1M rows but most of times using different slicer combinations,data is displayed in Desktop.But Im facing issue when published same report into service where data not getting displayed atleast for 1 date , 1 value chosen in 2 other dimension slicers,coming with error as 'Visual cannot display data with exceeded available resources' but what i see for combination in Databricks side Query it is just 10 rows and same is coming up in PBI desktop.
So please help me why Report is throwing for even less data.Any help will be highly appreciated.
I have built report without Premium subscription earlier but as we now got Premium and workspace moved to Premium,still im seeing same error after republishing report
