I experimented with measures in a Synapse data warehouse in Fabric and experienced some issues:
Examples of what goes wrong:
- New measure button in the data pane is greyed out but without an explanation given. I found out that this is the case when the table is not part of the default dataset.
- When editing an existing measure it takes me to the SQL Editor and not the DAX editor. So I'm unable to edit existing measures.
- Table columns are not recognized in DAX while creating or editing the measure.
- Measures are not executed nor visible in the data preview.
- Measures with failures are still stored in the table but when opening them again, the measure is converted to [DaxExpressionRedacted]
2 Comments
- kblackburn1New Member
I am experiencing the same. I realize the product is still in preview, but this is a sizable gap in my opinion. Thank you for posting!
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Need an option to save PBIP files without data (the .abf files)
We need an option to save the PBIP without saving the ABF file, just like the PBIT file is saved without data. As it is now, we will violate company security policies that don't allow storing data ...heve2 hours agoNew MemberNew608Views39likes6CommentsiOS Shortcuts Support for Direct Access to Power BI Reports
We are looking to deploy several Power BI reports to support emergency response activities. The intended users are primarily non-technical staff who do not use Power BI currently, but who would benef...Default81295 hours agoFrequent VisitorNew3Views0likes0CommentsSupport Fabric Workspace Identity for custom APIs
Currently, Fabric Workspace Identity cannot be used to authenticate against custom APIs protected by Microsoft Entra ID. Azure Managed Identities support requesting an access token for a specific AP...frithjof_v8 hours agoCommunity ChampionNew63Views5likes0CommentsAllow the target pipeline reference in Invoke Pipeline / ExecutePipeline to be set dynamically
Problem Today, the Invoke Pipeline activity (and legacy ExecutePipeline) requires picking the target pipeline statically at design time — a fixed Workspace/Pipeline selection in the UI, which serial...JONATHANHAUN23 hours agoNew MemberNew9Views0likes0CommentsReset Bookmark Navigator Selection to the Default Published View on Browser Refresh
In Power BI Service, when a user selects a bookmark through a Bookmark Navigator, the bookmark identifier is appended to the report URL. If the user refreshes the browser page, the report reloads in ...vivek1234423 hours agoMicrosoft EmployeeNew6Views0likes0Comments