Forum Discussion

cferraz_hemav's avatar
cferraz_hemav
Helper I
3 years ago

Migration from ODBC to DataFlow - Date hierarchy

Hi all!   We are trying to escale our PowerBI reports because current connectors in physical machines and addressing the refresh to materialized views in PostgreSQL database was causing performance...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi cferraz_hemav ,

 

Instead of relying on the automated date/time hierarchy, you could try creating a custom date table in your DataFlow or Power BI data model. This table should include all the necessary date attributes (such as Year, Quarter, Month, and Day) and any additional time-related attributes you need.

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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

cferraz_hemav's avatar
cferraz_hemav
Helper I
3 years ago

Thanks for your answer...however is not a solution for my problem because doing that I continue losing the measures already in the models.