Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
matthewwelchUp
New Member

Excel data transform issue

I'm having a specific issue on data importing.  I import a spreadsheet that has several columns set as percentages.  Power BI on import automatically changes those types.  When I edit the query to transform the data back to a percentage, it takes effect on the query screen, but on close and apply it never applies to the dataset so I'm still looking at decimals.  I'm not sure what to do at this point.  Monkeying with the spreadsheet prior to upload hasn't produced anything.

 

The only time it actually uploaded properly was when I tried uploading it directly to the cloud PowerBI instead of  Power BI desktop, but I need it in desktop

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Can you go into the data model and change it to a %? Modeling tab, click column, click %


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

Can you go into the data model and change it to a %? Modeling tab, click column, click %


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I must be blind or something.  Maybe it's just Monday...

 

I still wonder why the query doesn't do the job, though.  Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors