Change source from csv into website

[alexcatala]

Hi,

I have been trying to change the source of multiple tables into a website. Currently, all of the reports( .xslx ) are coming from my own device. But recently I have moved them into a SharePoint in order to work collaborative within my team and could bring these reports straight from the online SharePoint.

I have tried to change it but keeps showing my computer details:

C:\Users\a.catala\OneDrive - UK\Dash\-job.xlsx

As we want to make this collaborative we established this SharePoint were every single one of us can upload and update file and feed the Power BI. But unfortunately, when they try to refresh the data it keeps showing (The supplied file path must be a valid absolute path. 

I have copied the link URL and it keeps not making a link to extract the data.

https://usa.sharepoint.com/teams/HRdepartment_HR-Management/Shared%20Documents/Forms/AllItems.aspx?i...

I want to create a parameter to could include all these 3 reports together, but I have already created all the queries in the query settings. Is there any way to create a parameter within these 3 reports keeping the queries I have established them?

Thanks for your help.

[amitchandak · Accepted solution]

@alexcatala , to change the source, Create the required source in a new file. Right click on the table in edit query mode and choose advance editor and get the source details. Take these details into the old file

refer : https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/