Error 800 with 3 tables imported from CSV (March 2023 Version of PBID)

[bernatagulloesbrina]

Describe the problem

Hello,
I just loaded 3 tables from csv files stored in my pc
Then I tried to add the date dimension from bravo and got an error 800

I tried saving the file, closing and opening up again, but the error persists

Regards!

Bravo version

1.0.1

Tabular model

Power BI Desktop, import mode

Power BI

Version: 2.115.663.0 64-bit (march 2023)

Steps to reproduce the behavior

1. Load files
2. Try to add Date Table --> Error
3. Save File
4. Close File
5. Open File
6. Try to add Date Table --> Error

Additional context

No response

Screenshots

No response

Anything else ?

No response

[albertospelta]

Hi @bernatagulloesbrina, this appears to be an internal error generated by the Analysis Services engine, similar to the one reported in issue 597.

Does the error occurs if you disable the holidays in the Date table?

[bernatagulloesbrina]

indeed, turning off holidays does seem to solve the problem
so it's a problem on microsoft's side?
thank you -- for most of my use cases holidays are not that relevant

[albertospelta]

This is probably the issue @marcosqlbi mentioned here #597 (comment)

We spot a bug in Power BI Desktop that crashes with certain DAX expressions and we are waiting a response from MS.