Forum Discussion
powerbi datatypes problem with SharePoint List
Hi all,
I've got something really wierd going on when i connect to a sharepoint list from power bi.
When i connect to the list all the field datatypes come up as text values...
Cant understand why fields which are number data types in the sharepoint list are opening as text in powerbi
Any help would be appreciated
thanks for the link. I will investigate abit alternatives because it is the first time i created a sharepoint list using excel upload feature. In most other Sharepoint Lists created manually from scratch, never had this issue in powerbi.
7 Replies
- vanessafvg
Community Champion
can you share your power query code?
hi,
im rather new to powerbi. Is the code displayed in the Advanced editor window?
- vanessafvg
yes that is correct. althought to be fair i am not 100% sure it will pull it through as the correct data types, power query usually if you have that setting on will automatically do a convert for you based on the first few hundred rows of data, it will decide what data type it should be and that will have a change type step. but if you can share the power query code as you illusted in the advanced editor window that would be useful to understand the steps.
