How to Connect Power BI to a File/Folder in OneDrive

Here is a recent video that shows how to get data from a OneDrive file using the SharePoint Folder connector. 

Just build the new query, and then copy the steps of the new query and replace the Source (and maybe a few more steps) of your existing query.  You may have to update your step references so the each step references the table/variable before it (e.g., #”Changed Type”). 

WIth this approach, your original table will stay in the model with all the relationships, measures, visuals, etc. still intact.

Below, it is another great video to find the path for a individual file in OneDrive.