Forum Discussion
Difference between the two logs generated by PowerBi.
We have cleared cache as well.
Under --> Options -->Global --> Data Load
At first, limit clause got appened with the query we pass. But later on, it didnt behave as expected.
Could you suggest any changes that needs to be done in power query (.pq) file.
Regards,
Sushma
I am not aware of a way to tell Power Query not to use the cache. Maybe set the cache size to zero?
Yes, I tried that. It didnt work either.
But could you suggest, how do we actually desgin a custom connector which supports limit under native query.Sorry, that's outside my area of expertise. Haven't learned about custom connectors yet.
HI SushmaMudayappa,
For enabled 'Native Query' support in custom connector, you can refer the following links:
Implement Native Query support in your Power Query Custom Connectors | Microsoft Power Query
Native query support in the Power Query SDK - Power Query | Microsoft Learn
REference link about how to create custom connector:
Creating your first connector - Hello World - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng