Forum Discussion
Sharing a date table across different projects
Hi Anonymous ,
What I mean is, if your source is a database like SQL, MYSQL, ORACLE you can ask team to create a date dimension (confirmed dimension) table, which you can use it accross in all power bi applications. Else you need to create a date table every time you create new app.
Hope this helps you.
Regards,
Pavan Vanguri.
Hi Anonymous ,
If you create a date table in the power bi data model, its individual to the particular app.
You cannot share the same with the another app, alternatively you can create a dimension table in the data source like sql, and the same can be used to all others applications.
Please let me know if you still have any questions, happy to help to you.
Regards,
Pavan Vanguri.
Hi Pavan Anonymous, many thanks for taking the time to get back to me.
What do you mean when you say "...you can create a dimension table in the data source like sql". Please forgive my ignorance, I am very new to Power BI and I am not sure what a dimesion table is.
Kind regards,
Martin
Hi Anonymous ,
What I mean is, if your source is a database like SQL, MYSQL, ORACLE you can ask team to create a date dimension (confirmed dimension) table, which you can use it accross in all power bi applications. Else you need to create a date table every time you create new app.
Hope this helps you.
Regards,
Pavan Vanguri.
Thanks Paven Anonymous , I think I've got it now :-)