Unable to open the already existing and working pbix file getting Mdx script error

[anee123]

Hi,

Till yesterday, the pbix file was working fine and we did not do any changes to break it, but from today, we are not able to open the pbix file in power bi desktop file, howeever same file when uploaded in power bi service using upload file option, its opening in power bi service!!

this is the below error we are getting:

Something went wrong

Failed to save modifications to the server.Error returned:'MdxScript(Model)(109,26)
An argument of function'DATE'has the wrong data type or the result is too large or too small.
The current operation was cancelled because another operation in the transaction failed.'.

This looks like a datatype issue in the model, but we are not able to open the file in desktop to rectify it. Or is the datatype messed up in the datasource end, please suggest.

[v-lionel-msft]

Hi @anee123 ,

Please create support ticket .

Best regards,
Lionel Chen

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

[anee123]

I tried that already 🙂 no luck..same issue I am getting. Is this something to do with the Power BI version or the datatype issue at the source end???

[Pragati11]

Hi @anee123 ,

To me it looks like a data-type issue as the error clearly says that.

[anee123]

Even i suspect that, how do i debug and fix the issue when I am not able to open the pbix in the first place. Should I go to the source database and check if any changes happened there? is there any other way to debug this issue. Is there a way I can go the exact datatype and fix the issue, the error just says datatype issue.

[Pragati11]

Hi @anee123 ,

As you mentioned, you are able to publish the file in Power BI Service, try downloading the pbix file from Power BI Service after publishing it. Then try opening it and modifying your data type.

Thanks,

Pragati