Measure Error: The following system error occurred: The handle is invalid. | Version: 2.79.5768.721

[P3Sven]

Hello lovely PBI community,

since the last Power BI Desktop Update (Version: 2.79.5768.721 64-bit (March 2020)) I get the following Error Message with my simple Measure:

SumDaysExclStudent = CALCULATE(SUM(Plan[Days]);FILTER(Plan;Plan[RollCluster]<>"Student"))

My Datamodel looks like this:

Table Projects (unique ProjectID)

ProjectID        Leader

1                     A

2                     B

3                     B

Table Plan

ProjectID           RollCluster          Days

1                        Consultant          1

2                        Consultant          2

3                        Student               1

Both tables are connected by ProjectID (Filter Direction Projects > Plan) with DirectQuery Storage Mode.

My simple target Table on visual page looks like that:

Target Table

Leader     SumDaysExclStudent

A              1

B              2

Could you help me with this Error message? I haven't found anything in web and maybe its a new one with the new PBI version.

Thank you in advance!

BR,

P3Sven

[MFelix · Accepted solution]

Hi @P3Sven ,

Believe this can be specific error. I had a similar error on a previous version and could not find anything I send out the frown and got contacted by Microsfot that solved that identified the issue for me. Another thing you can do is post this on the issues part of the forum for experience they handle this on a timely basis.

Just telling this because some errors are on some machines / installments and on other machines everything is normal. Looking at the tables and code everything should work normally.

[Anonymous]

Hi Community Users,

After the recent release of Power BI Desktop March release(Version : 2.79.5768.721), I am getting error while pulling a measure in my report. The error says "The following system error occurred: The handle is invalid."

Kindly please let us know why this error is getting to me but other random users in my organization is not facing this issue.

If I publish this report on Power BI Service then also the error persists.

Currently I have connected with snowflake database using Direct Query mode in Power BI.

Kindly suggest how to resolve this issue and why few users are getting this type of error.

[Anonymous]

Thanks @MFelix 

Really appreciate the quick response on the issue highlighted. Will open the support ticket with the Microsoft.

Regards,

Ashutosh Singh

[MFelix]

Hi @Anonymous,

This is very specific so s I refere you better open a ticket on the issues part of the forum, sometimes there are small things like drivers or similar thar can impact some uses, but the microsoft team can help you to get the details.

[v-alq-msft]

Hi, @P3Sven 

Based on your description, I created data to reproduce your scenario. Two tables are all from Sql Server with DirectQuery mode. You may simplify the measure as follows.

SumDaysExclStudent = 
CALCULATE(
    SUM(Plan[Days]),
    Plan[RollCluster]<>"Student"
)

Here is the result. It works properly. I'd like to suggest you create a ticket for this issue.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[P3Sven]

Hi Allan / v-alq-msft !

Sorry for my late replay (had to do lot of corona virus analysis)

Thank you very much for testing it! I already have done it in this way aswell, but I don't understand why its not working with CALCULATE / FILTER anymore? Whats different in the new version? With PBI February version everything worked fine.

I've lot of other CALCULATE FILTER Measures and some aren't working without FILTER 😕

But thank you for your help, I will open a ticket for it 🙂

Cheers and stay healthy!

Sven

[MFelix · Accepted solution]

Hi @P3Sven ,

Believe this can be specific error. I had a similar error on a previous version and could not find anything I send out the frown and got contacted by Microsfot that solved that identified the issue for me. Another thing you can do is post this on the issues part of the forum for experience they handle this on a timely basis.

Just telling this because some errors are on some machines / installments and on other machines everything is normal. Looking at the tables and code everything should work normally.

[P3Sven · Accepted solution]

 Hi @all,

after couple of weeks and lot of calls with indian support, I got the following reply regarding the issue:

Lets wait for the next PBI Update...

BR,

Sven

[gauravkh]

@P3Sven 

Can you please share the steps to disable V3 model

[P3Sven]

Hi Miguel @MFelix !

sorry for late reply! Thank you for your experience and suggestion. I will open an support ticket 🙂

BR,

Sven