Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Power BI creating many unwanted columns while getting data from Share point list.   e.g. of unwanted field names, FileSystemObjectType, Id, ServerRedirectedEmbedUri, ServerRedirectedEmbedUri.... &...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

     

    Regards.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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.