cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gsu421 Visitor
Visitor

Date and Value recognize as String in Excel when pulling data from PBI Publisher Excel Plugin

I'm importing data set from PowerBI to Excel and creating a pivot table. I realize two things:

Date Field:

Issue

They aren't reconize as date field in Excel.

Impact

This prevents me from grouping the date and view data with date hierarchy.

Things I tried

I tried to change the dataset property on Date Column using Transform in Query Editor. I tried to set them to Date/Time or Date, but none of them works. 

 

Value Field:

Issue

They aren't reconize them as a value field in Excel.

Impact

I cannot drag the value field to Values quadrant in the pivot table.

Things I tried

My workaround to this is to create a measured field in the dataset in PBI. 

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Date and Value recognize as String in Excel when pulling data from PBI Publisher Excel Plugin

Hi @gsu421,

 

Based on test, when you "connect to data' function to import data from power bi, these data will analysed to 'general' excel type.


I think current it not support to keep original data type when you use this plugin to conect data from power bi. Perhaps you can share your requirement to ideas forum.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)