Forum Discussion
RE: Measures created using XMLA end point
- Anonymous1 year ago
Hi bhavana_dfz,
Thank you for reaching out to the Microsoft Fabric Forum Community.
When you create and publish measures using the .NET TOM library via the XMLA endpoint, those measures become part of a dataset hosted in the Power BI Service. When you connect to that dataset in Power BI Desktop (through a live connection), Power BI treats it as a "read only" model. That’s why you can’t click on those measures to see or edit the DAX expressions it’s not just your code; it’s how Power BI handles all published datasets.To make changes to those measures, you’ll need to use tools that are designed to work with published models, such as Tabular Editor or by updating them through your TOM code again. Power BI Desktop can’t edit datasets once they’re published it’s only for building or viewing. If you want to freely edit measures, do it before publishing, or use external tools that support the XMLA endpoint.
Best regards,
Prasanna Kumar
Thank you for answering my question Anonymous . I have a follow up.
Why is viewing and editing measures not an issue when semantic models are published via power bi desktop? I can connect 'live' to those publilshed semantic models from my desktop again and view measures after they are published. How are models published via XMLA end point different from those published via desktop ?