Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
LamSar
Helper III
Helper III

Dataset creation Power BI Premium

We are currently using analysis services for Power BI, using a pro license.

We are thinking about switching to Power BI Premium.

The existing datamodels can be migrated from AAS to Power BI Premium.

 

I have a few questions:

- How / where do we edit the existing data models after the migration? At this point we add measures, add tables,... using tabular editor or Visual studio.

- How / where do we create a new datamodel: In Power BI service? or do we keep doing that in Visual Studio?

 

Can I find a tutorial somewhere? I've been looking on the web, but haven't really found what I am looking for. 

 

1 ACCEPTED SOLUTION

Hi @LamSar 

Yes, you can use datamart, and you can refer to the following link.

Get started with datamarts (preview) - Power BI | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

View solution in original post

3 REPLIES 3
v-xinruzhu-msft
Community Support
Community Support

Hi @LamSar 

For the Q1:

How / where do we edit the existing data models after the migration? At this point we add measures, add tables,... using tabular editor or Visual studio.

After you migrate the data source from AAS to Power BI Premium, you can edit the data model by connecting with Power BI Desktop or Tableau Editor, you can refer to the following link.

Connect the data source by Tableau Editor 

Connect Tableau to Power BI Datasets - Visual BI Solutions

Connect the data source by Power BI Desktop.

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn

Q2:How / where do we create a new datamodel: In Power BI service? or do we keep doing that in Visual Studio?

(1)You can create a new data model in Power BI Desktop, then publish it to the Service. But you need to import data source to it first. You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started#connect-to-data

How to Build a Power BI Data Model: 2 Easy Steps - Learn | Hevo (hevodata.com)

(2) You can create a new data model in Visual studio, then deploy it to Power BI Service.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#deploy-model-pro...

https://learn.microsoft.com/en-us/power-bi/enterprise/troubleshoot-xmla-endpoint#deploying-a-dataset

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

What about Power BI damart? That is included in Power BI Premium. 

Would this be a good choice to create new datamarts (instead of creating them in Power BI desktop)?

Hi @LamSar 

Yes, you can use datamart, and you can refer to the following link.

Get started with datamarts (preview) - Power BI | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.