CSV File as data source that is on Sharepoint

[vikashkarra]

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

[Anonymous]

How I have done this is as follows:

• Get Data: From Web
• Get the file URL in my sharepoint.
• Cut the URL where is the extension of the file I want to link, in this case, .cvs. 

  https://sharepoint.com/Folderspath/File.csvadditional information then https://sharepoint.com/Folderspath/File.csv

• Paste the URL
• Select the type of logon
• Check the query

[bilaharim]

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

[vikashkarra]

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!