Get Data

[RobbieL123]

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 

[RobbieL123]

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

[parry2k · Accepted solution]

@RobbieL123 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.⚡

[parry2k]

@RobbieL123 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.⚡

[RobbieL123]

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