How can You transform data in Power BI Desktop Excel as it is showing correct in power Query Editor

[MithaliGupta]

How can You transform data in Power BI Desktop Excel as it is showing correct in power Query Editor howerever even after applying changes in editor throuwing error

[MithaliGupta · Accepted solution]

So basically the formatting and calculations needed to be updated like cells were taking formulas instead of values... got this resolved thanks!!

[Anonymous]

Hi @MithaliGupta ,

In order to make troubleshooting and give you a suitable solution, could you please provide the screenshot with the error message and which steps you applied in Power Query Editor? Thank you.

Applied steps in Power Query Editor

Best Regards

[amitchandak]

@MithaliGupta ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.