Forum Discussion

KrisCachia's avatar
KrisCachia
Frequent Visitor
4 years ago
Solved

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 unders...
Need Help
  • KrisCachia's avatar
    KrisCachia
    4 years ago

    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. 

     

vanessafvg's avatar
vanessafvg
Community Champion
4 years ago

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.

KrisCachia's avatar
KrisCachia
Frequent Visitor
4 years ago

 

 

I simply connected to the SharePoint List. Didnt do any other settings. Here is the code:

 

let
Source = SharePoint.Tables("companysiteurl", [Implementation=null, ApiVersion=15]),
#"1e4fcf33-6d58-4fd4-bb9d-61306e5da796" = Source{[Id="1e4fcf33-6d58-4fd4-bb9d-61306e5da796"]}[Items]
in
#"1e4fcf33-6d58-4fd4-bb9d-61306e5da796"