Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Space in number type when imported from Sharepoint List

Hello everyone,   While updating my dashboards this morning, a problem showed up for all of them (different PowerBI files, different dataset, same sharepoint site):   The number fields are no lon...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I partially fixed the issue. It all started when an IT admin changed the regional settings for the sharepoint Site. Consequently, I modified the same for my PowerBI files in settings. If it now works for currency, it still can't recognize the space separator in numbers (local fr-FR). The only solution was to remove separators in the sharepoint list view.

     

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 months ago

I found a better workaround for when the SharePoint site is set to French and numbers can't be read from Lists.  I created a Power BI Gen1 Dataflow - that reads the List values without Errors.  It saves them as numbers which I can then pull into Power BI Desktop via the Dataflows connector.

However the Power BI Gen1 Dataflow loses the detail for columns that are Table-type or List-type, e.g. SharePoint Lookup or List columns. I guess I could build 2 queries and Merge them on ID, but quite clunky to maintain.