You have a Fabric tenant that contains JSON files in OneLake. The files have one billion items.
You plan to perform time series analysis of the items.
You need to transform the data, visualize the data to find insights, perform anomaly detection, and share the insights with other business users. The solution must meet the following requirements:
Use parallel processing.
Minimize the duplication of data.
Minimize how long it takes to load the data.
What should you use to transform and visualize the data?
You are designing a Fabric semantic model named Model! for a financial analytics workspace. Modell includes a DAX measure named Measure1 that returns total sales.
You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $8,880.00, ta,880.00, or yv.sve.ee.
You have a report that uses the Currency column to identify which symbol and format string to display. In the report Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column.
You create the following DAX formula.
FORMAT = SELECTEDVALUE('Currency'[Format])
You need to ensure that Measure1 appears correctly in visuals. The solution must minimize logic duplication. What should you do?
You have a Fabric workspace named Workspace-!. You have a GitHub repository named Repol. You need to connect Workspacel to the main branch of Repol. Which information should you provide?
You have Fabric tenant.
You need to create a sematic model that delivers fast report rendering, minimizes query latency, and maximizes flexibility for DAX calculations.
Which storage mode should you select?
You have a Fabric workspace named Workspace1 that is assigned to a newly created Fabric capacity named Capacity1.
You create a semantic model named Model1 and deploy Model1 to Workspace1.
You need to publish changes to Model1 directly from Tabular Editor.
What should you do?
In Microsoft Fabric, semantic models (formerly datasets) can be managed using external tools like Tabular Editor. To push or publish changes directly to a Fabric workspace from Tabular Editor, the workspace must support XMLA endpoint connectivity with read-write access.
Explanation of Each Option
A . For Workspace1, enable Git integration.
Git integration allows source control and versioning of items in a Fabric workspace. It is intended for lifecycle management of artifacts and does not provide the connectivity required for Tabular Editor to publish semantic model changes.
B . For Workspace1, create a managed private endpoint.
A managed private endpoint provides secure connectivity between Fabric and external data sources. It is not related to the ability to publish semantic models through XMLA.
C . For Model1, enable external sharing.
External sharing governs who can access the model outside the organization. This does not affect publishing workflows from developer tools.
D . For Capacity1, set XMLA Endpoint to Read Write.
This is the correct choice. The XMLA endpoint provides a programmatic connection point for external tools like Tabular Editor. By default, the XMLA endpoint is enabled only in read-only mode. Changing the setting to Read Write allows developers to push changes, update metadata, and deploy semantic models directly from Tabular Editor into the Fabric workspace.
Summary
To publish changes to a Fabric semantic model using Tabular Editor, the XMLA endpoint of the assigned capacity must be set to Read Write. Without this configuration, Tabular Editor can only connect in read-only mode and cannot deploy updates.
Reference
Use the XMLA endpoint in Microsoft Fabric
Manage capacities in Microsoft Fabric
Kevin Howard
12 days agoMichael Hernandez
1 month agoSarah Williams
1 month agoRebecca Green
2 months agoEdward Smith
2 months agoTimothy Lee
3 months agoBetty Collins
4 months agoOlivia Rogers
4 months agoDennis Robinson
5 months agoWilliam Bailey
5 months agoKimberly Smith
6 months agoRobert Williams
5 months agoBetty Flores
5 months agoHarold Adams
6 months agoSandra Nguyen
5 months agoSharon Peterson
5 months agoAhmed
6 months agoDeonna
6 months agoJesus
7 months agoJerlene
7 months agoLorean
7 months agoKayleigh
8 months agoWilda
8 months agoHarley
8 months agoKimbery
8 months agoJosefa
9 months agoJade
9 months agoNathalie
9 months agoDustin
9 months agoDaren
10 months agoJennifer
10 months agoRaymon
10 months agoRoslyn
10 months agoCiara
11 months agoAileen
11 months agoMollie
11 months agoLinsey
11 months agoLayla
12 months agoDick
12 months agoBette
1 year agoTerrilyn
1 year agoStefania
1 year agoBeckie
1 year agoKendra
1 year agoRashida
1 year agoJudy
1 year agoDeane
1 year agoCarlee
1 year agoJacquelyne
2 years agoAndra
2 years agoLeandro
2 years agoGermaine
2 years agoAdela
2 years agoMerrilee
2 years agoReita
2 years agoTyisha
2 years agoLaquanda
2 years agoLeonor
2 years agoLeota
2 years agoLachelle
2 years agoFletcher
2 years agoMarla
2 years agoKrystal
2 years agoJacki
2 years agoValene
2 years agoLauran
2 years agoKaron
2 years agoMarge
2 years agoTamekia
2 years agoMary
2 years agoStephaine
2 years agoLing
2 years agoJonelle
2 years agoKerry
2 years agoNobuko
2 years agoalison
2 years agoAlex
2 years agopereexe
2 years agokorey
2 years agoAsuncion
3 years agoAlexas
3 years ago