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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Claster
Advocate II
Advocate II

API Localization & Round number

Hello All. I insert data into powerbi using API and I have a some problem.
1. In my profile I set Russian localization but my dates in table look as mm.dd.yyyy, I thought if I set Russian localization that my dates should be like dd.mm.yyyy.
2. Coluld I show dates without time.

1.png

 

3. Problem with numbers in hints

2.png

4 REPLIES 4
v-haibl-msft
Microsoft Employee
Microsoft Employee

@Claster

 

  • This setting will only change the language displayed in the site but will not change your date format. Please refer to this document.
  • In PBI Service, you’re not able to change the date format. You can change the format from Date/Time to Date in PBI Desktop. Please refer to this document.
    API Localization & Round number_1.jpg
  • This setting can only control the decimal places in “data labels” but cannot impact the one in “Tooltips”. If you also want to change the one in Tooltips, we can do it in PBI Desktop.
    API Localization & Round number_2.jpgAPI Localization & Round number_3.jpg

Best Regards,

Herbert

@Herbert_Liu

I can't use PowerBI Desktop because this data set was created by PowerBI API http://docs.powerbi.apiary.io/#

In example i don't see how i could set localization and format of numbers

@Claster

 

These two functions are not supported in Service but only in Desktop. You can only change the value format in your data source but cannot do it after insert data into PBI Service. You can also vote this idea in this site.

 

Best Regards,

Herbert

@v-haibl-msft you missed KEY phrase "...I insert data into powerbi using API...". So, this guy can't use Power BI Desktop a-priory. Only JSON scripts.

 

We have similar problems to.


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.