Problem with format coming from sharepoint list

[Marty_75]

I have MS Forms that the user's filled out every day, I have flow that bring that data in Sharepoint list. Even thought the format in th MS Form is number and the column in Sharepoint list is also number, when I connect to the sharepoint list by power bi desktop and go to power query, he still reconized it as text value.  I try to convert in power query to decimal but return as an error

I tried to convert it in power automate with compose or with variable and still upload a text value in sharepoint list. I tried many avenue mentioned in this forum (try a save as, etc...) with no luck.  What am I missing?

[Anonymous]

Hi @Marty_75 ,

I found this similar post: Error: "Can't convert to number", but the collumn ... - Page 2 - Microsoft Fabric Community

In the post, you can try the methods they discussed.

If you're still having trouble, please provide more details. If possible, provide a screenshot of the data type of the data from the previous step before the error.

Best Regards,

Stephen Tao

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

[Marty_75 · Accepted solution]

Hi @Anonymous ,

Thanks for the reply. I continued my research after posting and I was able to figured it out. In Power Query, by selecting the column that Power query could'nt auto detect the format and selected thoses options from the ribbon and it work!!

Change the format to DECIMAL as required.

If It could help someone else...