Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Getting Multiple XML Files from Sharepoint - Feels very inefficient, can I do better?

My datasets were not refreshing (credential errors) when I navigated to each of my three xml files using the web connector (when building my report in PBI Desktop).   It might be the exact composit...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I see.  Thank you.  So...
- Can I delete any helper queries that are lying around without doing any damage?
- Is the way I'm doing it the only way to bring in Sharepoint based xml files i.e For each one, get the whole folder and filter to the single file I require.  (It'd be greate if it automatically created a query for each xml file).
- Is there a way I can copy and paste the required M code?  (I tried this and it failed because t was referring to one of the helper files and their names can't be guaranteed).

 

Thanks.

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    Hi Anonymous 

     

    I would suggest starting again and deleting all the files as this will make it easier. 

     

    And sometimes the M code is different, so I would just do each of them individually to make sure it works as expected.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks all for the general guidance.  You gave me some good poiinters and I acquainted myself with the mechanics of 'M' a bit more and it became clear what was happening and I was able to sort it.