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.
How do i chagne the data type of data? I have connected a onedrive excel sheet and made a repot. Now i would like to change the data tyoe to $. However there is no option on the online version to change the data type. I know how to do it on the desktop version but cant figure it out for the life of me.
Solved! Go to Solution.
@afkeefe,
In Power BI Service, it is not possible to change data type of columns. Please connect to Excel file on OneDrive following the guide in the article below, then change data type , create reports there. And you can publish reports from Power BI Desktop to Power BI Service.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-onedrive-business-links/
Regards,
Lydia
how do you change the data type of a connected excel sheet from Onedrive for Business?
I know how to change the data type on the desktop version, but cant figure it out for the life of me on the online version.
@afkeefe,
In Power BI Service, it is not possible to change data type of columns. Please connect to Excel file on OneDrive following the guide in the article below, then change data type , create reports there. And you can publish reports from Power BI Desktop to Power BI Service.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-onedrive-business-links/
Regards,
Lydia
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.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |