Connecting and implementing Incremental refresh in Power Bi for Azure table storage

[Anonymous]

I have an Azure Tabular storage which needs to be connected to Power Bi. I am able to establish a connection and pull data to Power Bi but issue has started to happen due to large amount of data and that causes a refresh issue. Each time I do a refresh, its takes lot of time for refresh to complete, and this will be taking more time once the data size increases in tabular storage.

Now I am looking for ways how can I handle this and improve the performance. I am unable to do incremental refresh as I see "View Native Query" to be disabled though I have unchecked the Native Database query in Options and Settings--> Security. What next can I do improve this refresh part? and any suggestion as why incremental refresh is not working with Azure Tabular storage?

[sateshkumar]

Hello,

Can you please confirm if Azure table storage supports incremental refresh?

Thanks,

Satesh

[v-henryk-mstf]

Hi @Anonymous ,

On the one hand, the reason for the slow refresh is that the data source is too large, and on the other hand, the reason may be that the refresh time is set during the peak period. May wish to set the time to the night of the local time to see if the time has been shortened.

If your datasource can set up dynamic filters based on parameters, I think incremental refresh should works on it.

"View Native Query" to be disabled may be due to incorrect configuration steps, please refer to the following official documents for details

Incremental refresh for datasets

If the problem is still not resolved, please provide detailed error information and screenshoot. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-henryk-mstf 

thanks for response. dataset is large and thats the reason for refresh taking long time. On View Native Query being disabled, it is disabled from very first step. Even when my transformation is just to expand the records, View Native Query is disabled. Can you confirm the following:
1. if it is a issue with Azure Table storage that it doesn't support query folding?

2. Without Query folding, the incremental refresh cant be set up as we see warning 'Unable to confirm if M query can be folded'?

Also Not sure what you meant by dynamic parameter? is it RangeStart/RangeEnd parameter?

thanks