brett16
6 years agoNew Member
Status:
Completed
Format Strings don't work on a SSAS Model with Calculation Group(s)
AAS recently implemented Calculation Groups with big fanfare. However any SSAS / AAS Cube that has *any* users using Power BI in Live Connect mode cannot add this feature to their cube. I would be ...
zenzei2
6 years agoNew Member
Hi folks, I have the same issue here, and I have discovered something that might help in the struggle. The thing is, in my case, I find the following: When Calc groups are added to the model, yes, the measures become variant. But this is not an issue by itself!... If all FormatStringExpression of all Calculation Items are empty, then the behaviour of measures is unchanged (at least in my testings) - the usual format strings of normal measures are properly shown in graphs, business as usual, all happy If afterwards, I add just one FormatStringExpression to ANY of the Calculation Items, (including SELECTEDMEASUREFORMATSTRING () or any other), then the bug arises and graphs in PowerBI do not respect their source formatting (matrix is OK as you have reported) So in my case, it looks that the problem does not come from just 1500, or from adding calculation groups, but from adding a single FormatStringExpression to the model. Therefore, in my case so far I am able to add Calculation Groups and Items without and issue to an existing model (phew!), but not use the custom format feature. I hope this helps shed some light, and yes, Microsoft should solve this!
Recent ideas
Let Workspace Admins manage Fabric Policies
For example, allow a Workspace Admin to grant other identities the Contributor role, while also granting them higher privileges in certain areas, e.g. List Workspace role permissions (without resha...frithjof_v31 seconds agoCommunity ChampionNew40Views0likes3CommentsSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull2231 minutes agoAdvocate INew48Views1like3CommentsShow Refreshing indicator in workspace for semantic model refreshes from pipelines and XMLA
When I start a semantic model refresh by hand ("Refresh now") or from a schedule, the workspace list shows a spinning refresh icon next to the model. That way, anyone can see a refresh is running. T...JDownes3 hours agoRegular VisitorNew6Views0likes0CommentsREST API - exclude hidden report pages
For the "Reports - Get Pages" REST API call, exclude hidden report pages or indicate that the page is hidden.alec_johnson4 hours agoNew MemberNeeds Votes642Views32likes10Comments