Datamart final data set saving option

[gsunilkumar145]

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.

[v-luwang-msft · Accepted solution]

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

[gsunilkumar145]

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 .?

[v-luwang-msft · Accepted solution]

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

[v-luwang-msft · Accepted solution]

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