Forum Discussion
Datamart final data set saving option
Hi Team,
I have used visual query & created a new data set by merging 2 different tables but how can i save these finally created table.?
I didnt see any option of saving, when am connecting from Power BI Desktop, it is showing only 2 data sets.
Please find the below screenshot for your reference.
Hi gsunilkumar145 ,
In my opinion, it should automatically save, referring to the current official documentation :
To access auto-generated datasets, go to the Premium Gen 2 workspace and find the dataset that matches the name of the datamart.
refer:
https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-get-started
Best Regards
Lucien
Hi gsunilkumar145 ，
Not need subcription of Azure.refer article:
To create a datamart, navigate to your existing Power BI Premium Gen 2, Premium per capacity (PPC), or Premium Per User (PPU) workspace. Datamarts require a Premium Gen2 subscription. In your Premium Gen 2 workspace, select + New and then select **Datamart (Preview) to create a datamart.
And learn more details about Gen2 ,refer:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-gen2-what-is
Best Regards
Lucien
3 Replies
Hi gsunilkumar145 ,
In my opinion, it should automatically save, referring to the current official documentation :
To access auto-generated datasets, go to the Premium Gen 2 workspace and find the dataset that matches the name of the datamart.
refer:
https://learn.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-get-started
Best Regards
Lucien
Hi Lucien,
Thank you so much for your clarification.
If i want access the Gen2 to check my saved queries of Power BI Datamart , do i need separate subcription of Azure to view my Gen2 Work space .?
Hi gsunilkumar145 ，
Not need subcription of Azure.refer article:
To create a datamart, navigate to your existing Power BI Premium Gen 2, Premium per capacity (PPC), or Premium Per User (PPU) workspace. Datamarts require a Premium Gen2 subscription. In your Premium Gen 2 workspace, select + New and then select **Datamart (Preview) to create a datamart.
And learn more details about Gen2 ,refer:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-gen2-what-is
Best Regards
Lucien
