Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Proud to be a Super User!
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:
@henriquesilveir thanks for your response, but unfortunately not possible to do on a mac
Proud to be a Super User!
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.
Best Regards,
Dale
@v-jiascu-msft yep i tried that but it didn't work ta
Proud to be a Super User!
Hi @vanessafvg,
That's strange. Totally work in my side. I would suggest you create a support ticket here. Maybe something is wrong.
Best Regards,
Dale
@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.
Proud to be a Super User!
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
@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 🙂
Proud to be a Super User!
Hi @vanessafvg,
I totally agree with you. As we can see from the image of my first post, it works. Please check your Messages box for my email.
Best Regards,
Dale
Hi @vanessafvg,
I have reported this issue to the Product Team: CRI 95832755. I will update the progress here. Actually, the single $ would work, which is the second option in the list of Symbol.
Best Regards,
Dale
Hi @vanessafvg,
I'm afraid this is a limitation for now. I would suggest you try to use the PBI Desktop as a workaround.
Best Regards,
Dale
not an option due to being a mac but thanks @v-jiascu-msft
Proud to be a Super User!
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:
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.