Data not coming properly after SharePoint Integration with Power BI

[Pallab_Kundu]

We have integrated sharepoint incident data with PowerBi but few of the coulmn data are missing. Showing only "List" value.

In a source table few columns are taking only neumeric value instead of String data. While the original data in sharepoint only string value.  

[v-piga-msft · Accepted solution]

Hi @Pallab_Kundu,

---

@Pallab_Kundu wrote:

We have integrated sharepoint incident data with PowerBi but few of the coulmn data are missing. Showing only "List" value.

---

For your scenario, you could Go to Query Editor to have a check if you didn't expand the values in the [List]. You 'd better expand the [list] and you will see the values in Data view.

---

In a source table few columns are taking only neumeric value instead of String data. While the original data in sharepoint only string value.  

---

Currently, Power BI not support String data type, only text type. From your screenshot, it seems that your data looks like number type, so when you load in Power BI, it will automatically convert to numeric.

If you want your data to be text type, you also could change the data type under Modeling manually.

Best Regards,

Cherry