Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |