I am developing a report in Power BI Desktop for which I am using a native query through a ODBC connector and for development purposes, I have filtered the query for a small amount of data in the power query.
Also I am not loading the whole data into the memory in PBI Desktop and I am using parameters to filter out for a small chunck to be loaded in the local, so that I can edit them in the service.
I know for a fact that one cannot access power query after the report is published to a workspace or so.
I need for the table to be loaded fully in power query from my native query after which I parameterize the table for a small number of rows of data to be loaded in local.
But that operation is taking a lot of time since the number of rows is in the billions after the native query and filtering gives out a few thousand rows.
Any other relavant approaches on tackling this problem is much appreciated.
PS: I resorted to use native query to load data as the SQL query is complex and time consuming to build in power query fully from scratch.
