refreshing data

[milton]

Hi, my name is Milton, and i have the following problem

I have three transactional tables (invoices with all the details) being hosted in a Microsoft Azure Database, that I read over a view and I place one table in my model in power bi desktop.

At the time I have a total of over 10.000.000 records.

I have to refresh the data in power bi service 5 times over a 24 hours’ period.

I would appreciate a solution that will not refresh all years but only the last one

To be specific I have data for the years 2019, 2020, 2021 and 2022

So, only the year 2022

One solution that I found will not allow to download the dataset over the bi service and that is not suitable for my case since I set new users and roles all the time, so downloading updating and publishing again is very important for my team. It is not one man ‘show’.

Can you please provide a solution?

Thank you

[Anonymous · Accepted solution]

Hi @milton 

You can use Direct Query connection mode to connect to Azure DB , then create a measure or calculated column to return the date between year 2022 . For example :

Measure = CALCULATE(SELECTEDVALUE(DimProduct[StartDate]),FILTER(DimProduct,DimProduct[StartDate]>=DATE(2022,01,01) && DimProduct[StartDate]<=DATE(2022,12,31)))

In this way , you can get the data that between year 2022, then publish the report to Service ,and configure gateway for the dataset , once the gateway runs successfully , you can set scheduled refresh for the dataset .

Incremental refresh is not suitable for you , because when your report set incremental refresh , you cannot download the report in Service .

Best Regard

Community Support Team _ Ailsa Tao

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

[donsvensen]

Hi Milton,

You should have a look at incremental refresh - Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs