Deep Dive into Editing Semantic Models in the Power BI Service (Generally Available)

-

Mac users, rejoice — semantic model editing in the Power BI service is now generally available, bringing core modeling capabilities to the web.

Create New Semantic Models in the Web

You can now create new import semantic models from over 100 connectors, all within your browser.

Getting started:

1. Navigate to the Create page and select Get data.


This will launch the modern Power Query Get Data experience for you to discover and connect to data including sources like Excel, SharePoint, SQL Server, and more!

2. Choose your data source and configure connection settings.

3. Select the tables you want included in your semantic model.


From here you have the following 3 options:


Option 1: Create a report

This option takes you into the report editing experience in the Power BI service. Here, you can immediately start building a report on top of your newly created semantic model. The report editor provides all the familiar tools for designing visuals, adding filters, and customizing your report layout—right in the browser.


Option 2: Only create a semantic model

Selecting this option creates just the semantic model, without launching the report editor. You’ll land in the model editor in the web, where you can make further edits to your semantic model. This is ideal if you want to refine your semantic model, add relationships, create DAX measures, or configure row-level security before building reports.


Option 3: Transform data

This option allows you to perform rich data transformations using the modern Power Query editor in the web. After completing your transformations, you can choose to either create a report or a semantic model only, depending on your workflow.


Edit Existing Semantic Models in the Web

Not only can you create new import semantic models in the Power BI service, you can also make core modeling changes to your existing semantic models—all without leaving your browser. This includes many capabilities such as:

Manage relationships: between tables in the properties pane, diagram view, or the Manage relationships dialog. This includes support for autodetecting relationships for faster modeling.

DAX authoring: Create and edit DAX measures, calculated columns, calculated tables, and calculation groups with full IntelliSense support.


Edit properties: in the properties pane, including support for the model explorer.


Row-level security: Define and assign RLS roles to secure your data.

Power Query integration: Just like when creating new semantic models, Power Query is supported for editing existing models. 

Perform rich transformations using the Transform data dialog including using the highly demanded diagram view for visualizing query dependencies and structure.


Schema and data refresh: Refresh both the schema and data for your import semantic models by selecting Refresh in the ribbon.




Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Temporary enable and disable SSRS subscriptions

-
--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description ,        dbo . [Catalog] . Name ,        dbo . Users . UserName ,        InactiveFlags FROM dbo . Subscriptions      INNER JOIN dbo . [Catalog]      ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID      INNER JOIN dbo . Users      ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO
Read more

Microsoft AI Tour Singapore

-
Image
Register today for the Microsoft AI Tour in Singapore. For one day, immerse yourself with the latest Microsoft Cloud and AI products and solutions to help you gain a competitive edge and solve your biggest challenges.     Who should attend:    Senior leaders that are part of their organization’s AI transformation    During this event, you’ll be able to:    Get up close with real-world examples and demos on how to begin or continue your organization’s AI transformation  Connect with industry experts, partners and your peers to learn best practices and key next steps in your AI journey    Gain a fresh perspective while you broaden your understanding of the value of AI.      Here’s what to expect:    Opening Keynote : Hear from Microsoft leaders like Andrea Della Mattea , President Microsoft ASEAN , who are leading the era of AI ...
Read more