cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tiago_santos Frequent Visitor
Frequent Visitor

Decimal point not being imported by Power BI (using SAP BW connector)

Hi,

 

When I import decimal numerical data from SAP BW the decimal point isn't imported with it.

 

Example:

How the number is in SAP BW: 111.99 .How the number first appears in Power BI: 11199 . How the number is in Power BI after conversion to decimal number (either in query editor or in Power BI Desktop)  11199.00

 

I was using Power BI June release until last week, and this problem didn't exist, i.e. the decimal point was imported correctly. When I updated to the August release, the numbers in my models became wrong and I traced it to this problem.

 

For now I'm dividing all the numbers by 100 to get the decimal point to the right place. However this is not a good solution. 

 

I assume this is an issue with the SAP BW connector, is there a fix for this problem? Or will this problem be fixed in the next version of Power BI?

 

Thanks in advance.

1 REPLY 1
ankitpatira Super Contributor
Super Contributor

Re: Decimal point not being imported by Power BI (using SAP BW connector)

@tiago_santos From what you're saying it sounds like a bug in the connector. I would suggest you report it here. I would have used the same workaround you did.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 73 members 1,006 guests
Please welcome our newest community members: