Forum Discussion

milton's avatar
milton
Regular Visitor
4 years ago
Solved

refreshing data

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's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.