Forum Discussion
Help with a large database and summarising columns
Hi WalkerGBG
Based on my knowledge, it is impossible to summarise data when loading all the data.
You could use parameter to filter data when importing data.
Power BI Desktop Query Parameters, Part 1
When you unpivot table or group by data, is there any error message?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not sure as no experience with PowerBI really how Parameters could work.
Regarding the process I've followed
When I unpivot the columns from the table - that works and even though it's doing lots and lots of columns seems to work very quickly against my large datasource (completed in a minute or two)
When I then do Group By it takes about 40 minutes to run and then comes up with this error:
DataFormat.Error. We couldn't convert to Number
Details:
kmtlw.x.y
So looks like (I think) somewhere in my several thousand files that there's a text field in my data where it should be number
In the query that created this grouping "= Table.Group(#"Unpivoted Columns", {"Date1", "Attribute"}, {{"SumProduct", each List.Sum([Value]), type number}})"
Is there anyway to make it so that it nulls or ignores numbers (so handles these exceptions)?
Apologies - I meant to say thank you for replying. Appreciate you looking at this
