Exporting data from Power BI to Excel

Hi Paul,

sorry, completely misread this.

But not matter of the reasons, my answer was meant as an acknowledge that this feature is missing for some specific purposes.

However, there are workarounds at the moment (if DAX-studio doesn't work for you, you can use the R-feature within PBI as an alternative to export tables with a max. length of 100k rows).

Re descriptive statistics, I see no reason at all, to switch to a different tool. (Apart from the time you need to) Write your functions in M. Currently writing a blogpost about it, but here is a sneak-preview to give you a taste (Excel's TREND-function):

(YList as list, NoOfIntervalls as number) =>
let
    Source = Table.FromColumns({YList}),
    xAxis = Table.AddIndexColumn(Source, "Index", 1, 1),
    Rename1 = Table.RenameColumns(xAxis,{{"Column1", "y"}, {"Index", "x"}}),
    AvgX = List.Average(Rename1[x]),
    AvgY = List.Average(Rename1[y]),
    x = Table.AddColumn(Rename1, "xX", each [x]-List.Average(Rename1[x])),
    y = Table.AddColumn(x, "yY", each [y]-List.Average(x[y])),
    xy = Table.AddColumn(y, "xy", each [xX]*[yY]),
    xXx = Table.AddColumn(xy, "xXx", each [xX]*[xX]),
    a = List.Sum(xXx[xy])/List.Sum(xXx[xXx]),
    b = AvgY-(a*AvgX),
    ListIntervalls = {List.Max(Rename1[x])+1..List.Max(Rename1[x])+NoOfIntervalls},
    TableIntervalls = Table.FromList(ListIntervalls, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Rename = Table.RenameColumns(TableIntervalls,{{"Column1", "x"}}),
    Values = Table.AddColumn(Rename, "y", each [x]*a+b),
    TREND = Table.Combine({Rename1,Values})
in
    TREND

Big advantage of M is that you can do recursive operations as well, there are LOG-functions – so a pretty good basis to get going with descriptive statistics in Power BI.

Should find a space where we could share these codes within the community as well…