Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI doesn't load Excel formulas properly

Hello,    I would like to ask a question related to Power BI or Queries Editor. I have a database in Excel with one large table. In this table, some of the columns consist of data or values and som...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello Anonymous 

 

I was not able to reproduce this error with an inconsistent calculated formula. What version of PowerBI/Excel do you use? Try to recreate the column.

 

Jimmy

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi guys, thank you very much for your help... Unfortunately, I cannot just share the original data I use...and when I tried to simulate a similar dataset, the error doesn't show. I created Excel source file with one calculated column and intentionally changed the formulas in the column to create inconsistent column formula error. When I loaded the data into Power BI the affected columns loaded properly. I will try to add at least printscreens to show you the situation. As you mention, one of the solution is to create another table and then connect them with ID. I also used workaround with new Calculated column. However, it's a pity I cannot create everything in Excel and I have to keep some of the outputs and calculations in Excel and some in Power BI. Our IT Dept approved Power BI Desktop 2.74.5619.862 32-bit. I told them there is a new version released...

 

Thank you for your help

 

Best

 

David

 

Printscreens here: 

 

https://www.dropbox.com/s/y2qwfug6xmhl6lg/Excel_Formula.JPG?dl=0

 


https://www.dropbox.com/s/85dsh2t2aw0zy8f/Excel1.JPG?dl=0

 


https://www.dropbox.com/s/pzs4pd79fihe1o9/PWBI1.JPG?dl=0

 


https://www.dropbox.com/s/unqecla82ysufis/PWBI2.JPG?dl=0