Query Update

[Ritesh_Air]

Hi,

So I have to add two columns to my existing sql query in Power BI. I thought it would be fairly non time consuming. But the table the query referes to has 3.5 million rows and it takes hours to update. Is there an easy way, where I can add those columns without it querying the whole database?

Thanks,

Ritesh

[mahoneypat]

I missed the part about you using your own SQL query. Query folding would not apply. Good luck.

Regards 

Pat

[amitchandak]

@Ritesh_Air , is it a direct query or import mode

[Ritesh_Air]

@amitchandak import

[amitchandak]

@Ritesh_Air , see if you can schedule incremental refresh for this

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[Ritesh_Air]

@amitchandak 

Thanks. I have seen incremental refresh before. It's for different purpose. What I want is to add few columns without refreshing the whole table. So I don't have to wait until it runs the query. Looks like there is no way to force it when I use 'sql query' as my data source.

Incremental refresh is for new set of data after certain date. 

thanks

ritesh

[v-yingjl]

Hi @Ritesh_Air ,

You can add some SQL statements to filter the data in advance when getting data from the data source then add new queries to add columns.

Best Regards,
Yingjie Li

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

[Ritesh_Air]

Hi @v-yingjl 

Actually, my whole query is SQL only. I was thinking of filtering it with one record to add the columns and then remove that filter but wouldn't it run again when I remove the filter?

All I want is to apply changes without refreshing the entire table, and let a person just use the service to do that...

@mahoneypat I am not sure how the query folding will help?

thanks,

Ritesh

[mahoneypat]

Make sure you are maintaining query folding, if it is available for your source.  Please see this link for more details.

https://docs.microsoft.com/en-us/power-query/power-query-folding

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat