cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vikashkarra
Helper I
Helper I

CSV File as data source that is on Sharepoint

Hello - so here's my conondrum and hoping someone can help me out with it! I have two data sources - 1 is a SharePoint Online List - which I'm able to connect to. The other is a CSV File (that is downloaded from a CRM tool called Insightly). For now, I'm manually downloading the .CSV file from Insightly and want to put it on Sharepoint and have that as another data-source. How does one do this? The only thing that it looks like I can do is actually connect to the SharePoint Page and it's not seeing the .CSV File. Any help or suggestions would be greatly appreciated

3 REPLIES 3
Anonymous
Not applicable

How I have done this is as follows:

 

 

bilaharim
Frequent Visitor

You can use Get Data option in Power BI service(https://app.powerbi.com)  and select  FILES>Sharepoint-Team Sites.

 

Give the root URL and niavigate to the file from there.

 

Example :https://companydomain.sharepoint.com/sites/teamsitename

 

Regards,

Bilahari

Thanks - I figured it out. I placed the file out on a folder and connected to it via Get Data > Sharepoint Folder. My issue was that I guess I forgot to click on the 'Content' column to actually expand into the subset of data.

 

Thanks!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors