Table loads in local desktop client but not published dashboard via a browser
The underlying SQL brings back large amounts of data, but I use the right-hand filter pane to narrow down the search to a specific Invoice Date Range. Doing this will rewrite the query and send a new query to the table, decreasing the stress and load.
The first image, with the red privacy blocker, shows the local desktop version of my dashboard. The data loads perfectly fine and super fast using the filter pane to narrow down the results. However, the second image fails to load the table and I get a "Query has exceeded the available resources" error. How do I fix this?
I feel like there is something else going on than the size of the data causing the malfunction since I have done this process on other reports, some 10x the size as this query, and it works fine. Just don't understand why it is working perfectly in the desktop version of PBI but fails when published. Any ideas?