How to add dimdate table in the custom semantic model. Please make a video on this sir.
@adilmajeed84393 ай бұрын
You need to bring your date dimension either into a Lakehouse or a warehouse
@AmitChandak3 ай бұрын
You can get it using dataflow Gen 2 or SQL Refer to this video- kzbin.info/www/bejne/nWSldomOhsmeY8k 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
@ravsha853 ай бұрын
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?
@AmitChandak3 ай бұрын
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.