Power BI Dataset - Format of field is incorrect

[Anonymous]

I have created a Dataset file to pull in the data, clean it up and complete all of the calculations. This file is published to the PBI Service. 

Then in my Inspection report, I pull in the data and create the charts.

I have concatenated SalesOrderNumber and SalesOrderLine to give me the Sales Order Detail. I am having problems with the Sales Order Detail field. This is my key field to tie to other tables but the format is different in this report. In the report it keeps adding a .0000000000000. This was in the original dataset but I cleaned it all up. 

I have messed around with this for so long and cannot resolve the issue. 

If I republish the Data Master and refresh the Inspection report, it clears up, then within a minute or two, it reverts right back to the incorrect format. 

Please Help. 

Data Master

Inspection Report

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids

[Syndicate_Admin]

Don't @kweibelt,

Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it.

Best regards
Qin eyelids