Issue while getting data from Share point List to Power BI.

[Anonymous]

Power BI creating many unwanted columns while getting data from Share point list.

e.g. of unwanted field names,

FileSystemObjectType, Id, ServerRedirectedEmbedUri, ServerRedirectedEmbedUri.... & many more.

Please suggest some workaround for this issue..

Thanks in Advance!

[nandukrishnavs]

@Anonymous  - You can use the "Choose Column" button to select only required columns.

[Anonymous]

Thanks a lot @nandukrishnavs  for your response.

I already have tried the same but issue is, my source SP list has 50 columns and i am getting almost 140 in PBI and many of the columns name you can refer in screen shot. cause of which the identification of fields also tough.

[nandukrishnavs]

@Anonymous  - Try OData source instead of SharePoint list.

URL will be - https://<sharepoint site address>/_vti_bin/listdata.svc

[Anonymous]

@nandukrishnavs  have already tried oData, Share point list & share point online list. same issue persists everywhere.

[amitchandak]

@Anonymous 

Refer: https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper

https://ssbi-blog.de/blog/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-file/

[Anonymous]

@amitchandak  Thanks a lot for sharing the blogs, I am looking at them and shall keep you posted at the earliest.

Regards.

[Anonymous]

@amitchandak unfortunately we do not have permission to download the power bi cleanup or dax studio tools.

[v-xuding-msft]

Hi @Anonymous ,

---

@Anonymous wrote:

@amitchandak unfortunately we do not have permission to download the power bi cleanup or dax studio tools.

---

Due to this, I'm afraid you need to clean the data up manually. Maybe you could try expending the columns selectively.

Best Regards,

Xue Ding

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