Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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 have already tried oData, Share point list & share point online list. same issue persists everywhere.
@Anonymous
Refer: https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
@amitchandak Thanks a lot for sharing the blogs, I am looking at them and shall keep you posted at the earliest.
Regards.
@amitchandak unfortunately we do not have permission to download the power bi cleanup or dax studio tools.
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.