dashboard files directly from sharepoint environment

[Nelleke-NL]

I now have a nicely working dashboard that I share with other users. They only consult.
The source files are on my local laptop. I download these excel files from sharepoint  ../kengetallen to my d: drive and after updating, I publish the report. I have paid licences.

The files are located in sharepoint ../kengetallen. This directory only contains the source files for the report.

Can I adjust the report so that it refers to files in the SP environment instead of the local directory? I do not understand the MS text properly and see the only solution as a complete new structure. But then there should be another way. Who can give me the steps on what to do? I'm just a well-intentioned amateur/volunteer in a non-profit organization. My English is not optimal but my Dutch is excellent! 😉 Translated with Google

[Nelleke-NL]

Yes, now I did the good way! SOmetimes is the right choice just the problem and solution!

I get the right data en copied the path to the path in the querys wih a lot of functions. Now it works 🙂

[amitchandak · Accepted solution]

@Nelleke-NL , If you have data in sharepoint, you should be able directly load that

Process is same as one drive: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links