Where to place csv file with data to be used in a report

[ovonel]

I have a csv file that I need to use in a report...

I want to put it in a path, so I can be picked up by PowerBI, but I am not sure how to or where...

I tried puting the file in SharePoint... but from PowerBI I can only retrieve the metadata, not the data inside the file:

What's the optimal place to put this file?

I thought of putting the file directly here, but it only seems to accept .rdl and .pbix files:

[v-pbandela-msft]

Hi @ovonel,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @ovonel,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @ovonel,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Akash_Varuna  for the helpful response.

As suggested by Akash_Varuna,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[Akash_Varuna · Accepted solution]

Hi @ovonel Did you transform the data after getting it through SharePoint Connector through get data ?

You can place the data in SharePoint , OneDrive or even localy since you have already uploaded to sharepoint please try this 
Use "Get Data" > "SharePoint Folder" in Power BI to connect and retrieve the data, ensuring you transform the file content instead of just metadata.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance