Using 'Power Query' and 'Transform Data' in a Report using data from Semantic Model

[Anonymous]

Hello Members,

I am a new Power BI learner and  I am stuck in a project where I only have access to Semantic Data model and I need to work and create transformations on a particular table from the data. I can create visuals but I cannot transform data. What are the options I have apart from creating measures, as measures have limited usage, I cannot use measures in slicers.

[Anonymous]

Hi rajendraongole1, thanks for the quick reply, I'll add more.

Hi @Anonymous ,

Clicking here will prompt you to add a local model, confirming this will change the connection mode from live connection to direct query. you can then create calculated columns and use them for the slicer.

Best Regards

[rajendraongole1 · Accepted solution]

Hi @Anonymous  - If you only have access to the Semantic Data Model (e.g., an Analysis Services model, Power BI dataset, or another live connection), your ability to transform data is limited because you cannot use Power Query to manipulate the data.

You can create calculated columns in the semantic model to transform or categorize data.

NewColumn = IF([ExistingColumn] > 50, "High", "Low")

If your model owner allows, you can request aggregated views or calculated tables at the source level.

While measures can’t be used in slicers, they can still create dynamic insights in visuals by calculating metrics on the fly.

Total Sales = SUM('Sales'[Amount])

Although working with a semantic model limits your data transformation capabilities, you can still achieve meaningful insights through calculated columns, DAX measures, parameters, and collaboration with data owners. If possible, request permissions for a more flexible connection mode, or suggest adjustments to the semantic model to accommodate your needs.