Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ainur Akmar]

Hello!

Does anyone know how to deal with this error? I googled and try some of the possible solutions but it didn’t work how I wanted it to be 🙁

DataFormat.Error: We couldn’t convert to Number.
Details: 40755 / 40756

Is it possible to combine the two numbers together without them being like this: 4075540756

Could anyone have any suggestion or advice? Thanks in advance.

Ainur 🙂

——————————
Ainur Akmar
——————————

[Mehdi HAMMADI]

Hi Ainur,

What do you mean by combine?
What are you trying to achieve on what data?
How the data looks in starting point and how you want to get them at ending point?

Did you see this article : How to Audit and Fix DataFormat Error in power Query – Ruki’s Blog (rukiatu.com)

——————————
If any discussion or answer help, please mark it as “Recommend”
——————————

Best regards
Mehdi HAMMADI

MCT | MCSA BI Reporting | MCSE Data Management and Analytics | Data Analyst Associate
2019 Ruby Award Dynamic Communities
——————————
——————————————-

[Ainur Akmar]

Nevermind I´ve solved it! Thank you!

——————————
Ainur Akmar
——————————
——————————————-

[Mehdi HAMMADI]

So what was exactly the problem and how did you solve it?

——————————
If any discussion or answer help, please mark it as “Recommend”
——————————

Best regards
Mehdi HAMMADI

MCT | MCSA BI Reporting | MCSE Data Management and Analytics | Data Analyst Associate
2019 Ruby Award Dynamic Communities
——————————
——————————————-