Showing results for 
Search instead for 
Did you mean: 
Not applicable

Report issue

Am getting below error while opening the dashboard . When click on upgrade report the Data model is no more exists . How to fix this issue?




Regular Visitor

Last week I discovered a really weird issue in Power BI desktop. I have written a simple DAX measure to calculate a CAGR using linear regression fit. It consists of several components (VAR sumx, sumxx, sumy and sumxy). The code worked excellent on a column with units (type: whole number), but I failed to get it working on another data source with Revenues (type: $). All x data (years, type: whole number) and y data are positive. 

To my surprise, sometimes sumxy was showing negative numbers, leading to completely wrong results. 

After debugging for a long time, I didn't find anything wrong with the code and decided out of desperation to change the format of the Revenue column from $ to whole number in the power query editor. Since then the code works perfectly fine. 

I'm completely puzzled by the root cause of the issue, but would like to save other Power BI users from this issue. 

Any ideas what went wrong here?



 Type dollar sign.PNG

Community Support
Community Support

Hi @Anonymous ,


If the issue still exists, you could try to open a support ticket. It is free if you have a Pro account.

Go to Scroll down and click "CREATE SUPPORT TICKET".


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Not applicable

Yes, Our team raised a ticket with Microsoft team. I am yet to hear the resolution steps from them.

Super User
Super User

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors