Forum Discussion

Flip89's avatar
Flip89
New Member
5 years ago

Data not loading from Sharepoint List to PowerBI for 2 columns

Dear all,   I have columns that are showing errors in Power Query in Desktop PowerBI as shown below. I have tried cleaning access permisions. Did not help.   HPPP SPOC field type is "Single choic...
Need Help
Flip89's avatar
Flip89
New Member
5 years ago

Hi Ed!

 

Not sure what y mean? It is showing me exactly as in screenshots above, no matter if I click on "Record" or "Table" or white space within same field.

 

Data is there. Find below extract of list item from web. "L2rt" being "MSM Owner email" column from above screenshot - column that works:

 

So when I check "l2rt" online I get the object as below:

When I do the same for "OData__x00a_is1" I get an error though data is there:

 

Similar for the Action owner email column. Will not paste here as I assume problem is of similar nature.

 

Cheers!

Filip

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    5 years ago

    If you click on the white area next to the yellow word Record or Table, it will show you the contents of that record/table below. 



    Either way, this doesn't appear to be a Power BI issue, but something you need to get with your SharePoint admin and see what is going on with these fields in the list.