Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Paginated Reports Query

Hello All,    I have created the paginated report, and the visual is table which have columns from different tables and no aggragate column is used as columns only few stings based columns are ther...
Please help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried using a measure at the end in dataset, still same 2nd error

bradsy's avatar
bradsy
Microsoft Employee
3 years ago

Can you try limiting the amout of data, put a Top N clause to see if this is because you are pulling too much data with your query? Also, you might have more information in the log file that could help diagnose. The file is at C:\Users\(you)\AppData\Local\Microsoft\Power BI Report Builder\15.7\Traces

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is the code which got generated with in-built functions, I tried using top N, but the query is not getting validated.

    Please guide me if i am missing anything.

    DEFINE
        VAR vFromDateTableStartofMonth1 =
            IF (
                PATHLENGTH ( @FromDateTableStartofMonth ) = 1,
                IF (
                    @FromDateTableStartofMonth <> "",
                    @FromDateTableStartofMonth,
                    BLANK ()
                ),
                IF (
                    PATHITEM (
                        @FromDateTableStartofMonth,
                        2
                    ) <> "",
                    PATHITEM (
                        @FromDateTableStartofMonth,
                        2
                    ),
                    BLANK ()
                )
            )
        VAR vFromDateTableStartofMonth1ALL =
            PATHLENGTH ( @FromDateTableStartofMonth ) > 1
                && PATHITEM (
                    @FromDateTableStartofMonth,
                    1,
                    1
                ) < 1
        VAR vToDateTableStartofMonth1 =
            IF (
                PATHLENGTH ( @ToDateTableStartofMonth ) = 1,
                IF (
                    @ToDateTableStartofMonth <> "",
                    @ToDateTableStartofMonth,
                    BLANK ()
                ),
                IF (
                    PATHITEM (
                        @ToDateTableStartofMonth,
                        2
                    ) <> "",
                    PATHITEM (
                        @ToDateTableStartofMonth,
                        2
                    ),
                    BLANK ()
                )
            )
        VAR vToDateTableStartofMonth1ALL =
            PATHLENGTH ( @ToDateTableStartofMonth ) > 1
                && PATHITEM (
                    @ToDateTableStartofMonth,
                    1,
                    1
                ) < 1

    EVALUATE
    SUMMARIZECOLUMNS (
        'ResultData'[Sample],
        'ResultData'[Date Sampled],
        'ResultData'[Sampling Point],
        'Analyte'[Analyte],
        'ResultData'[Class],
        'ResultData'[Result],
        'ResultData'[Status],
        'PRData'[PR],
        FILTER (
            VALUES ( 'DateTable'[Start of Month] ),
            (
                vFromDateTableStartofMonth1ALL
                    || 'DateTable'[Start of Month]
                        >= DATEVALUE ( vFromDateTableStartofMonth1 )
                            + TIMEVALUE ( vFromDateTableStartofMonth1 )
            )
                && (
                    vToDateTableStartofMonth1ALL
                        || 'DateTable'[Start of Month]
                            <= DATEVALUE ( vToDateTableStartofMonth1 )
                                + TIMEVALUE ( vToDateTableStartofMonth1 )
                )
        ),
        RSCUSTOMDAXFILTER (
            @SiteDEPT,
            EqualToCondition,
            [Site].[DEPT],
            String
        ),
        "TotalSamples", [TotalSamples]
    )