Forum Discussion

PiBouBou's avatar
PiBouBou
Frequent Visitor
6 years ago
Solved

Combine queries and flag include in the refresh

Hello,   I have two queries, one is 20 millions rows dated last year that has no movment. The other is the once a day actualised data. It takes 1 hour to upload the data. I then split in two queri...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You are describing incremental refresh, which is a feature in Power BI.  Please see this link for more info.  Fortunately, it is now available w/ just a pro license (not just premium anymore).

 

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

 

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

Regards,

Pat

 

PiBouBou's avatar
PiBouBou
Frequent Visitor
6 years ago

Hi,

 

thanks for the prompt reply.

 

I have heard of that, but I was quite sure that data could just be appended, whereas I need an Update or Insert scenario because I I replace a sliding month every day. But looking some post, it looks like the identical data will be deleted first.

 

Thanks again.