cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanessafvg Super Contributor
Super Contributor

developing a report in power bi service - data types?

is there a way of converting a data type in the service.

 

I sucked in an excel file into the data sets,  but i want to convert the decimal to currency, is there a way to do this?  The issue is that i have set the currency in excel but the service doesn't seem to be inheriting the currency, only the numerical format.

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
13 REPLIES 13

Re: developing a report in power bi service - data types?

y@vanessafvg hello, is not possible!

 

You can only change the field type into power bi desktop. 

 

My suggest: you could download a .pbix file in service, change it and republish. 

 

Take a look how to do this below:  print4.png

 

 

Re: developing a report in power bi service - data types?

y@vanessafvg hello, is not possible!

 

You can only change the field type into power bi desktop. 

 

My suggest: you could download a .pbix file in service, change it and republish. 

 

Take a look how to do this below:  print4.png

 

 

Highlighted
vanessafvg Super Contributor
Super Contributor

Re: developing a report in power bi service - data types?

@henriquesilveir thanks for your response, but unfortunately not possible to do on a mac


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
v-jiascu-msft Super Contributor
Super Contributor

Re: developing a report in power bi service - data types?

Hi @vanessafvg,

 

How did you format it in the Excel?

I did it by right-click the column and choose "Format Cells". The format seems still valid in the Service. Please refer to the snapshot below.

developing-a-report-in-power-bi-service-data-types

 

Best Regards,
Dale

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

Re: developing a report in power bi service - data types?

@v-jiascu-msft yep i tried that but it didn't work ta


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
v-jiascu-msft Super Contributor
Super Contributor

Re: developing a report in power bi service - data types?

Hi @vanessafvg,

 

That's strange. Totally work in my side. I would suggest you create a support ticket here. Maybe something is wrong.

create-ATicket

 

Best Regards,
Dale

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

Re: developing a report in power bi service - data types?

@v-jiascu-msft definitely doesn't work, i just retried, works in neither the desktop nor serivce, it comes through as a whole number.  I need it to be currency - someone else tried it and didn't work for them either.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
v-jiascu-msft Super Contributor
Super Contributor

Re: developing a report in power bi service - data types?

Hi @vanessafvg,

 

Can you share the Excel file? Only a little piece is needed that can reproduce the issue. BTW, I have Excel 2016. The contents in Excel are formatted as a table.

 

Best Regards,
Dale

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

Re: developing a report in power bi service - data types?

@v-jiascu-msft i created an excel file with 2 row with 2 columns in and formatted it as table, it was dummy data and saved it that is excel 2016, not to sure if the sharing will resolved this,  because it was really simple nothing complicated.   if you send me your email i can send it to you thank you Smiley Happy

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 222 members 2,352 guests
Please welcome our newest community members: