Forum Discussion
Data Mart Migration Help
why are you migrating to data marts?
I would migrate AAS cubes to Power BI Premium datasets.
in PBI datasets you can manage partitions the same way you do in tabular models.
R1k91 thanks for your answer.
We are trying to reduce the monthly costs a little, in addition to finding it interesting to use SQL queries using datasets that have already been modeled, within the business model we have here, it would make sense and could reduce the queries in Databricks a little.
But I confess that I reconsidered this idea, as I researched I think it is not possible to partition data using Power BI Datamarts... The data structure created behind it is an Azure SQL Server where the data is in "views" which I believe is not possible apply a partition function.
Do you frequently use premium datasets in your work? Do you have any best practice recommendations? How do you manage it? Does it via tabular editor, Rest API? If you could explain a little it would help me a lot.
Thank you again