Power Platform Community Forum Thread Details

I'm trying to get data from my PBI report through Power Apps by using "PowerBI.ExecuteDatasetQuery("my_groupId", "my_datasetId", "below_query")".

PBI desktop returned a DAX query that I used (below), but all I get is this:

Any ideas where and what I can change to get the data I am expecting? Works fine in PowerAutomate, but I am not a fan of triggering a flow as this is something thousands of users may trigger couple times a day.

"DEFINE
                VAR __DS0FilterTable =
                                FILTER(
                                                KEEPFILTERS(VALUES(PBItableName[email])),
                                                PBItableName[email] = ""user@domain.com""
                                )
                VAR __DS0FilterTable2 =
                                FILTER(
                                                KEEPFILTERS(VALUES(PBItableName[Date_Column])),
                                                OR(
                                                                PBItableName[Date_Column] >= DATE(2024, 1, 1),
                                                                PBItableName[Date_Column] < DATE(2025, 1, 1)
                                                )
                                )
                VAR __DS0Core =
                                CALCULATETABLE(
                                                SUMMARIZE(
                                                                PBItableName,
                                                                PBItableName[email],
                                                                PBItableName[Name],
                                                                PBItableName[Column1],
                                                                PBItableName[Column2],
                                                                PBItableName[Date_Column]
                                                ),
                                                KEEPFILTERS(__DS0FilterTable),
                                                KEEPFILTERS(__DS0FilterTable2)
                                )
                VAR __DS0PrimaryWindowed =
                                TOPN(
                                                501,
                                                __DS0Core,
                                                PBItableName[email],
                                                1,
                                                PBItableName[Name],
                                                1,
                                                PBItableName[Column1],
                                                1,
                                                PBItableName[Column2],
                                                1,
                                                PBItableName[Date_Column],
                                                1
                                )
EVALUATE
                __DS0PrimaryWindowed
ORDER BY
                PBItableName[email],
                PBItableName[Name],
                PBItableName[Column1],
                PBItableName[Column2],
                PBItableName[Date_Column]"

Categories:

Power Apps Pro Dev & ISV