Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Incremental refresh with numbers as date

Hello everyone! We have a fact table that contains a number to display the date. The format is CYYDDD. For instance 120001 = 01.01.2020. I already have a Power Query function to convert this numbe...
Need Help
  • Nimai123's avatar
    Nimai123
    5 years ago

    Hello joshua1990 

     

    Oracle connection is fine.

     

    The only way to find that the incremental refresh is working fine is to, try to refresh your dataset manually or scheduled and see if it completed in lesser time than usual.

     

    Have a look at this Video 

     

    Regards,

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago

Nimai123 : Thank you! 
Since I am using the oracle connection, it should work, right?

is there any chance to check if the incremental refresh is working properly ?

Nimai123's avatar
Nimai123
Icon for Post Patron rankPost Patron
5 years ago

Hello joshua1990 

 

Oracle connection is fine.

 

The only way to find that the incremental refresh is working fine is to, try to refresh your dataset manually or scheduled and see if it completed in lesser time than usual.

 

Have a look at this Video 

 

Regards,

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!