Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Can you go into the data model and change it to a %? Modeling tab, click column, click %
Can you go into the data model and change it to a %? Modeling tab, click column, click %
I must be blind or something. Maybe it's just Monday...
I still wonder why the query doesn't do the job, though. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.