Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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.
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/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.
User | Count |
---|---|
23 | |
20 | |
11 | |
9 | |
7 |
User | Count |
---|---|
49 | |
31 | |
20 | |
18 | |
15 |