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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors