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...
  • 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.

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.