Data connector Navigation Table - How to not fetch full data set ?

[Anonymous]

With large dataset it is an issue when previewing and refreshing data in Navigator.

It takes a long time and it is unecessary load to my service.

I would like to send different http queries to my reporting API.

 - one in Navigator previews (e.g. -- example.com/data?limit=50)

 - another when I actually load data (e.g. -- example.com/data)

I did not find anything in documentation and examples.

Is it posible to do ?

[v-qiuyu-msft]

Hi @Anonymous, 

I'm afraid it's not supported to achieve it. You can try to use Blank Query connector, and go to Query Editor, click on Advanced Editor, write complete Power Query to retrieve data. See: 

https://docs.microsoft.com/en-us/powerquery-m/accessing-data-functions

https://community.powerbi.com/t5/Desktop/How-to-create-Blank-query-and-Table-in-Power-BI/td-p/161311

Best Regards,
Qiuyun Yu

[polandoz]

I have the same issue. Did you find a solution to this?