Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Get Data

Hi all,

 

Please could someone help me with this issue?

 

I'm trying to set up a power BI to Sharepoint folder.

 

These are the steps I have followed:

1. Open BI Desktop 

2. Get Data

3. Other

4. Search for Sharepoint 

5. Use Sharepoint List 

6. Copy my Root URL 

7.  I want to get to this folder -> Operations-> Data-> All orders Report

8.  So I click on Operations

9.  And I get this

10. Now I'm stuck - how to read any of it (it says Table contents is empty) and all of the files say null.

 

Any help be much appreciated

 

Thanks 

Need Help
Show and Tell

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous are you going to use files from the SharePoint folder, like excel or CSV files? if that is the case then you should use the SharePoint folder to getting data instead of the SharePoint list.

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi parry2k this is what I did for doing a Sharepoint folder 

       

      Then I copied by root URL in and I get this

       

      So still stuck 😕

       

      Any suggestions?

       

      Thanks 

       

       

       

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous check this post, I hope it helps.

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks parry2k managed to do the job! Got another problem now though 😞 

     

    Do you know why I have got mixed date creations? (Some as actual Dates and some as errors that say could not parse the data ? 

     

    Thanks for all the help