You can get it using dataflow Gen 2 or SQL Refer to this video- ua-cam.com/video/g3BEVXQdk-g/v-deo.html With little modification, you should be able to create a date table using SQL in warehouse medium.com/@amitchandak/power-bi-direct-query-date-table-in-sql-server-b5f4fe0f6d3d
Hi Amit, could you please explain that "if we rename the columns in the custom sematic model then how does the refresh from the Default to custom model recognize that change and refresh the new data in to the custom model?
Default and custom semantic models have no relationship. No changes are migrated from one to the other. If you rename a column in Lakehouse and Warehouse, you have to refresh the tables in the Edit Table.
How to add dimdate table in the custom semantic model. Please make a video on this sir.
You need to bring your date dimension either into a Lakehouse or a warehouse
You can get it using dataflow Gen 2 or SQL
Refer to this video- ua-cam.com/video/g3BEVXQdk-g/v-deo.html
With little modification, you should be able to create a date table using SQL in warehouse
medium.com/@amitchandak/power-bi-direct-query-date-table-in-sql-server-b5f4fe0f6d3d
Hi Amit, could you please explain that "if we rename the columns in the custom sematic model then how does the refresh from the Default to custom model recognize that change and refresh the new data in to the custom model?
Default and custom semantic models have no relationship. No changes are migrated from one to the other. If you rename a column in Lakehouse and Warehouse, you have to refresh the tables in the Edit Table.