- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Power BI Publisher for Excel transforms values into text

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-27-2016 10:56 PM - edited 11-27-2016 11:03 PM

I have several calculated columns (decimal-type) in PBI, which work well when I create PBI reports. When I connect to Excel using "Connect to Data" the numbers convert to text, and manipulating/ranking the numbers in an Excel pivot table becomes impossible. How can I make sure the numbers come through as values, not as text?

## Numbers convert into text when exporting back to Excel

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-27-2016 10:53 PM

I have several calculated columns (decimal-type) in PBI, which work well when I create PBI reports. When I connect to Excel using "Connect to Data" the numbers convert to text, and manipulating/ranking the numbers in an Excel pivot table becomes impossible. How can I make sure the numbers come through as values, not as text?

## Re: Power BI Publisher for Excel transforms values into text

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2016 12:18 AM

Are you sure they turn to text? Analyse in Excel doesn't support implicit measures - you must write explicit measures in Power BI first. Said another way, you can drag a column of numbers to the values section in Power BI, but you can't do it in Excel connected to Power BI

## Re: Numbers convert into text when exporting back to Excel

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2016 12:20 AM

Duplicate post http://community.powerbi.com/t5/Desktop/Power-BI-Publisher-for-Excel-transforms-values-into-text/m-p...

## Re: Power BI Publisher for Excel transforms values into text

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2016 03:53 AM

MattAllington, I have explicit measures built I use for the Values section, but for Rows section, I (try to) use calculated columns. I have about 400k rows that need to be ranked, but I'm unable to do that as the Pivot table treats the row values as text (99.89, 997, 99.6, etc.).

## Re: Power BI Publisher for Excel transforms values into text

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2016 11:36 AM

Well that certainly sounds like a bug then. You should report it

https://powerbi.microsoft.com/en-us/support/

## Re: Power BI Publisher for Excel transforms values into text

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-28-2016 11:20 PM - edited 11-28-2016 11:21 PM

Hi @Otso,

What is your data source? Would you mind sharing me sample data of your scenario?

I make a test using my sample data, but I am not able to reproduce your issue. When I connect to my dataset that has calculated column(decimal-type) from Excel, I can successfully drag the calculated column to ROWS section. You can check the following screenshots to get more details.

Thanks,

Lydia Zhang

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: Power BI Publisher for Excel transforms values into text

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-03-2017 08:51 AM

I have the same problem. Also if I transform explicitly the type via power query to Type.Int64 it will be handled in the data modell like text.

Is there anysolution

Thanks

## Re: Power BI Publisher for Excel transforms values into text

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

03-13-2018 02:45 AM

Same problem here with Excel 2016 and latest Power BI Add-in.

It passed 1 year.

Any solution for this?

It's very annoying and turns the add-in useless.