Forum Discussion

vikramjandoo's avatar
vikramjandoo
New Member
3 years ago

Power BI problem with Sharepoint list

Dear Community - Need help 

 

I've made a report with Power BI Desktop that uses Sherepoint's list as a source:

- I noticed on the 3rd or 4th of May that the data upload stopped working due to incorrect separators in the number fields (trying to enter 9,999,999.99 in American style - Power BI Desktop expects Finnish formats, example below)
- tried to change the country settings of Power BI Desktop, no effect (image below)
- also checked Windows country settings, looks correct
- Sharepoint's list is still ok in the browser (Chrome) user interface, i.e. in Finnish
- - the same report and its download works OK

 

 

 


- uninstalled and reinstalled Power DI Desktop, no effect
- the corresponding download from Excel works OK, as well as the numbers from the SQL database
- now I tried downloading with my credentials on a different workstation (the application was indeed in Finnish) -> ends up with the same error

 

Need Help

3 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi vikramjandoo ,

     

    Changing data type using locale in Power BI is a feature that allows you to specify the format of your data source when you import it into Power BI Desktop. This can help you avoid errors or incorrect conversions when your data source has a different locale than your Power BI Desktop.

    For example, if your data source has dates in the format dd/mm/yyyy, but your Power BI Desktop has the locale en-US, which uses mm/dd/yyyy, you can use the change type using locale feature to tell Power BI Desktop to interpret the dates correctly.

    To change data type using locale in Power BI Desktop, you can follow these steps:

    • In Power Query Editor, select the column or columns that you want to change the data type.
    • Right-click on the column header and select Change Type > Using Locale…
    • In the Change Type with Locale dialog box, choose the data type and the locale of your data source, and click OK. 

     

    Refer to:

    Change Type Using Locale with Power Query • My Online Training Hub

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • vikramjandoo's avatar
    vikramjandoo
    New Member
    3 years ago

    Nope Did not worked... this is weird problem same account works on other laptops...