Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Power BI Dataset - Format of field is incorrect

‎03-24-2021 12:03 PM

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 MasterData Master

 

Inspection ReportInspection Report

Labels:
Message 1 of 49
1,791 Views
0
48 REPLIES 48
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:30 AM

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

Message 49 of 49
1,275 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:25 AM

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

Message 48 of 49
1,276 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:22 AM

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

Message 47 of 49
1,276 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:20 AM

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

Message 46 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:17 AM

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

Message 45 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:14 AM

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

Message 44 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:11 AM

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

Message 43 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:09 AM

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

Message 42 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:06 AM

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

Message 41 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:03 AM

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

Message 40 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:00 AM

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

Message 39 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:57 AM

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

Message 38 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:55 AM

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

Message 37 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:52 AM

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

Message 36 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:50 AM

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

Message 35 of 49
1,276 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:47 AM

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

Message 34 of 49
1,276 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:44 AM

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

Message 33 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:42 AM

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

Message 32 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:40 AM

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

Message 31 of 49
1,277 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:37 AM

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

Message 30 of 49
1,277 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All