Forum Discussion

Ashish9201's avatar
Ashish9201
Helper I
3 years ago
Solved

Error : Couldn't load the data for this visual

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:...
Need Help
Ashish9201's avatar
Ashish9201
Helper I
3 years ago

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