Error : Couldn't load the data for this visual

[Ashish9201]

Hi,

Happy Monday!

I am receiving below error popup on Power BI service

Activity ID: b1322af5-aee0-4c86-99b9-f796fdea34cc
Request ID: 4ac16184-8b11-4469-906a-4ef42c142d8b
Correlation ID: 963f0f38-6719-91e8-0fda-8dd8c39fa3d3
Time: Mon Nov 21 2022 12:35:03 GMT+0530 (India Standard Time)
Service version: 13.0.19445.37
Client version: 2211.1.10948-train
Cluster URI: https://wabi-us-north-central-g-primary-redirect.analysis.windows.net/

Below screenshot for reference:

I am able to get visual on Power BI desktop app. Can you please help me on this?

Regards,

Ashish Gupta

[Anonymous · Accepted solution]

Hi @Ashish9201 ,

What data source and connect mode you are using?

There are several posts that have similar error message, check if they could help.

Solved: Refreshing data - The command has been canceled.. ... - Microsoft Power BI Community

Solved: Failed to save modifications to server - Microsoft Power BI Community

Solved: Composite Models using Power BI datasets, Calculat... - Microsoft Power BI Community

Best Regards,

Jay

[Ashish9201]

Hi @Anonymous ,

I am using dataverse to connect the datasource and the mode i am using is direct query since the dataset is large.

Here is the table which is getting perfectly loaded in the desktop but not on service page.

Below is one of the dax that i am using to get the data,

PW New Hire Training =

CALCULATE (

    SUM ( msdyn_timeentry[Duration (Hours)] ),

    FILTER (

        msdyn_timeentry,

        msdyn_timeentry[Timesheet Status] = "Approved"

            || msdyn_timeentry[Timesheet Status] = "Draft"

            || msdyn_timeentry[Timesheet Status] = "Submitted"

    ),

    FILTER (

        msdyn_timeentry,

        msdyn_timeentry[Internal Filter] = "New Hire Training"

    )

)

Can this dax be improved to get result on service page?

thanks,

Ashish Gupta

[Ashish9201]

Hi There,

Please, Can anyone help me with this issue on urgent basis!

Thank you,

Ashish Gupta

[Ashish9201]

Hi,

Can you please help me out on this?

Thank you,

Ashish Gupta