Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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 ?

 

 

 

Status: New
Comments
v-qiuyu-msft
Community Support

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
Frequent Visitor

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