cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

SAP Query - Change decimal precision of measure

Hi,

 

I am using a SAP BEx query to get my data by importing it to Power BI. Sadly for one of the measures the decimal precision in the query is set to 0 so I am getting the values without any decimal places. I am used from other products that I can overwrite said query setting. Is that possible in Power BI and if so, how?

 

I found that there is a setting "Precision.Decimal" in the advanced editor but either it isn't working or I am doing it wrong... Any suggestions?

 

Thanks in advance

Regards

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: SAP Query - Change decimal precision of measure

Hi @GnikEht ,

How did you get data from sap data source? SAP connector or web connector? 

According to your description, it sounds like connector recognize decimal fields as whole number and remove its decimal place. 
You can try to modify query table first change type steps to use decimal format to receive these values.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: SAP Query - Change decimal precision of measure

Hello,

 

thanks for the answer. I am using the SAP .Net connector 3.0. Momentarily I am just working on my locale machine. 

 

That measures setting in the query is set to 0 decimal places, that is correct. But I am used to (in SAP products) being able to change that afterwards in the front end. 

If I understand you correctly I have to change the query settings or what do you mean by "modify query table"? So there is no way to change this setting with Power BI?

Highlighted
Community Support
Community Support

Re: SAP Query - Change decimal precision of measure

HI @GnikEht ,

AFAIK, power bi will use 'any' type to store table from datasource, I'd like to suggest you check first step(source) of query table to confirm if power bi has received decimal type records correctly.

If you can't find out decimal place of your numeric values, it means power bi cannot recognize decimal values from current connection mode.
If this is a case, you can try to use old connection mode to confirm if this issue is related to sap connector 3.0 mode.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors