danielle_thoma1
8 years agoNew Member
Status:
Needs Votes
None Aggregation Function to Handle Pre-Aggregated Data
Add a "None" aggregation function that would allow pre-aggregated data to be displayed as is in Power BI visuals. We have several data sets where the data has already been aggregated. This is causing the data to be incorrectly displayed in Power BI when trying to do a drill-up / drill-down as we're forced to select an aggregation function (SUM, MAX, MIN, etc.). Examples of pre-aggregated data are price indices calculated for each level of a product hierarchy or data calculated at each level of a geography hierarchy to suppress some values at lower levels of the geography for confidentiality reasons. The use of a "None" aggregation in a Power BI visual / matrix would display the pre-calculated value for the selected hierarchy level as-is from the underlying data set instead of trying to re-aggregated data that's already been aggregated.
2 Comments
- danielle_thoma1New MemberSee the comments dated 10-28-2016 & 06-27-2018 in: https://community.powerbi.com/t5/Desktop/Pre-Aggregated-Data/m-p/54519#M22068.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Bring Back separating Power BI artifacts on a per web page basis
Previously, the ability to have different artifacts open on different web tabs was enabled. This was beneficial if you wanted to differentiate what environments you were in, working across three diff...zoe-dean19 minutes agoNew MemberNew32Views7likes0CommentsREST API Should expose credentials used in connections
When a consultant leaves a client, it's important to clean up any connections that may have the consultants credentials embedded within. I'm able to use the Fabric CLI to get the managed connections ...PeterDaniels31 minutes agoAdvocate IIINew8Views3likes0CommentsExpose full activity-level error details in Workspace Monitoring Eventhouse
Microsoft Fabric Workspace Monitoring exposes activity-level pipeline telemetry in FabricDataPipelinesActivityRunsLogs, including PipelineRunId, OperationId, ActivityIterationCount, ActivityName, Act...MarcoOnnis47 minutes agoNew MemberNew1View0likes0CommentsSQL Analytics Endpoint host name - CNAME or defined alias
The host name for a SQL Analytics endpoint is ugly. They look like this: random_ugly_alphanumeric-random_ugly_alphanumeric.datawarehouse.fabric.microsoft.com The first segment looks like it...Mike_Diehl2 hours agoNew MemberNew29Views2likes1Comment