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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

When connected to BW SAP...Sales results come is as text and numbers

Submitted by Anonymous on ‎08-24-2017 01:53 PM

When using the SAP BW Connection, if I pull in Actual Pounds, Gross Sales, Net Sales, etc from SAP the results come in as a mixture of text and numbers.  The text items come in with multiple decimals as shown below.  This causes a Type Missmatch error.  The strange thing is from the same Power BI Desktop, I can connect to SAP BW with a different login and when I do so, all of these catgories come in as numbers with no text (multiple decimal points).  What could be causing this?

 

 

Actuals Issues.png

Status: Needs Info
See more ideas labeled with:
5 Comments (5 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎08-25-2017 08:30 PM

Hi @Anonymous,

 

1. Please check if the login which has issue in Power BI desktop can return correct data on SAP BW side.

2. Please try to run the Power BI desktop latest version 2.49.4831.521 64-bit (August 2017).

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎08-25-2017 08:31 PM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎08-28-2017 07:32 AM

Yes...the same log in returns the cottect data when running BW queries and I have the most current Power BI Desktop version.  I always update the date the revision comes out.

v-qiuyu-msft
Community Support
Community Support
‎08-29-2017 01:39 AM

Hi @Anonymous,

 

Please enable the desktop trace log and repeat the steps to reproduce the issue, share trace log files with us.

 

Best Regards,

QiuyunYu

Anonymous
Not applicable
‎08-29-2017 08:20 AM

Here's the log from the trace...is there a different file that needed for review?

 

DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:49.2153015Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0048456"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:49.3451902Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.7523642"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.0976264Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000959"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.1005854Z","Action":"SqlTranslator/SqlParser/Parse","HostProcessId":"4912","SQL":"SELECT * FROM [Consumer Daily Report for External use]","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0127812"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.1134213Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0236274"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.1436569Z","Action":"Engine/IO/SAP Business Warehouse/GetProviderFactory","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0017801"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3449325Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0011800"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3441775Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0019688"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3464453Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0002700"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3464374Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0002868"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3503215Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0008396"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3502843Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0008874"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3515544Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0008680"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3514977Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0009332"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3529320Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0010185"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.3528944Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0011097"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.1138489Z","Action":"SqlExpressionTranslator/Translate","HostProcessId":"4912","IsRecognized":"True","Result":"(environment) => Table.RenameColumns(Table.PrefixColumns(environment[Consumer Daily Report for External use], \"Consumer Daily Report for External use\"), {{\"Consumer Daily Report for External use.Distribution Channel.Distribution Channel Level 01\", \"Distribution Channel.Distribution Channel Level 01\"}, {\"Consumer Daily Report for External use.ActualPounds\", \"ActualPounds\"}})","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.3316999"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4456054Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000325"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.0975933Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.3514920"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4491509Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000208"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4842328Z","Action":"Engine/IO/SAP Business Warehouse/Connection/Open","HostProcessId":"4912","ConnectionId":"96270142-504c-4a86-9a0e-0d65327c0c33","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:00.0851795"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.5694720Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000317"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4811191Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.4128113"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4811113Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.4129164"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4733545Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetryAttempt","HostProcessId":"4912","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.4320215"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4733292Z","Action":"Engine/IO/Db/SAP Business Warehouse/RunWithRetry","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.4320813"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.5706134Z","Action":"Engine/IO/SAP Business Warehouse/Command/ExecuteDbDataReader","HostProcessId":"4912","Behavior":"Default","CommandText":"EXECUTE MDX |WITH MEMBER [Measures].[Microsoft.Mashup.Engine.unscaled.0] AS([Measures].[00733D5YC5IRO9XQHAKNOZ4N4] * 1.0)\r\nSELECT\r\n    {\r\n        [Measures].[Microsoft.Mashup.Engine.unscaled.0]\r\n    }ON 0,\r\n    NON EMPTY DISTINCT(\r\n        [0DISTR_CHAN].[LEVEL01].ALLMEMBERS\r\n    )\r\n    PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON 1\r\nFROM [ZCOPA_M04/ZDZCOPA_M04_Q001_EXT] CELL PROPERTIES VALUE SAP VARIABLES [CURRENCY] INCLUDING [0CURRENCY].[USD]| WITH-OPTIONS(IgnoreEmptyResultset=true, USEFLATTENING=TRUE);","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.3234936"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:51.9619415Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000375"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:49.3419110Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:02.5851237"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:49.2693466Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":1,"Duration":"00:00:01.1818400"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:51.9693150Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":13528,"Tid":4,"Duration":"00:00:00.0000310"}
DataMashup.Trace Information: 24579 : {"Start":"2017-08-29T15:10:50.4530591Z","Action":"RemotePageReader/RunStub","HostProcessId":"4912","ProductVersion":"2.49.4831.521 (PBIDesktop)","ActivityId":"9bc001cc-b17e-4758-945e-f66c8fb7a33f

Idea Statuses