An unexpected error occurred (file 'xlattrmap.cpp', line 396, function 'XLColInfoMapper::AddToAttrMa

[Anonymous]

Hi, I update to the new Version (September 2018, 2.62.5222.601 (18.09) (x64))  and I´m getting this error: with the previous version works fine. 

Any Idea of what is happening?'

Thanks in advance. 

[Anonymous]

Hi all,

I'm getting a similar error today, while it has been working fine before:

An unexpected error occurred (file 'xldc.cpp', line 3691, function 'XLAggImpl_Set<11,1>::Accumulate').

Please advise. Thank yoU!

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test using the latest version of desktop: 2.62.5222.761 64-bit (September 2018). It worked well. What is your version of Power BI desktop?

Regards,

Frank

[Anonymous]

Hi @v-frfei-msft,

The problem persist in the version 2.62.5222.601, I didn't try with the new version that was realeased TODAY.  I let you know, when I try. 

Thanks, 

Nico 

[v-frfei-msft]

Hi @Anonymous,

What is your visual here? And could you please share your pbix or sample data to me to have a text ?

Regards,

Frank

[Anonymous]

Hi Vfrfei, 

Sure! could you please send me a email adress? I prefered not to post it here. 

The visual iam using is a table. 

Thanks.

[v-frfei-msft]

Hi @Anonymous,

Based on my research, that should be the issue of the  SelectedValue function.  As If I delete all the measures that use SelectedValue in the table visual, then it worked well. You can refer to the support page, once updated, I will let your know asap. Also you can keep an eye on that. Now you can use the previous version to open the pbix to work around.

Regards,

Frank

[Anonymous]

Thank you very much, since this is fix, Iam using the prevoius version of Power BI. For when do you estimate that this will be solved?

[v-frfei-msft]

Hi @Anonymous,

As the message in the support page, Next update @ 9/17/18 at 3:00pm PDT. So I think that will be sovled before that time. 

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Checked the support page, the issue should be resloved now. Could you please try again in your side? If any other question, feel free to let me know please. Alsp kindly mark my answer as solution to close the case please.

Regards,

Frank

[Anonymous]

Hello Frank, 

I tried again, but the problem persist. I tried deleting and downloading again the last version of Power BI, but nothing. Same error appears.

Please let me know if there is another solution for this issue. 

Thanks, 

Nico

[MagnusRosenPBI]

I am experiencing the same issue. I am also using SelectedValue function. This seems to be something that was broken in the latest update of Power BI desktop.

There is one strange thing happening for me.

My setup is that I have one "dataset" pbix file, which is in turn is used for around 10 different report pbix-files.

The dataset pbix-file defines the data model and perhaps around 100-150 different measures. It connects to one excelfile (which is stored on OneDrive for a different microsoft accout than the one used for PowerBI) and a Azure SQL database (SQL-credentials).

The strange things is that I get this error only in the "dataset"-pbix file, not in the reports that are depending on the dataset-pbix file. It shows up in the Matrix and Table visual for me. I have the exact same measures and settings in both files but it is only in the "dataset" pbix file that things break. 

This problem seems isolated to Power BI Desktop, I don't experience this problem in Power BI Service.

[MagnusRosenPBI]

I tested this on then newest release (I believe it was released today), version 2.62.5222.761 and the problem has disappeared.

Thus I would presume the problem is now fixed.

[Anonymous]

Yep! The problem has been solved with this new version! 

[michael_lagahit]

Hi All, 

We are still getting the same issue for this new released version 2.62.5222.761 64-bit (September 2018). We are using DAX SelectedValue function and Matrix as a visual. Seems that it is still not fixed yet. anyone can help and give some insights please?

Thank you so much in advance!