Forum Discussion
Direct query - how prevent full recordset from loading and only return filtered sets?
Our users would like to be able to use cross-report drillthru to review detail records from an enormous, 350 col wide, 900 million row table. Our 'header' report works well in import mode and w...
Hey, appreciate this a few years old now, but did you ever get it to work? I'm just looking at a similar situation now.
We prototyped a solution where the 'detail' report was kept in a parameterized paginated report that would run a restricted sql query against the main dataset. The PowerBI report included links to the paginated report that included URL parameters. It worked well for desktop users, but those URL parameters were not supported in the PowerBI mobile app, and the solution was abandoned.
The business group decided the problem wasn't suitable for PowerBI and took the work to a different technology.