Make data source type dynamically

[Anonymous]

Hi

I have multiple Excel spreadsheets stored in a local directory that I am using for development. 

I have the path in a parameter but when I am done I will eventually need to connect it to:

1. spreadsheets stored in SharePoint

2. SQL Server (SP or query used to generate some of the spreadsheets)  

If someone would please shed some light on how to go about achieving this that would be very helpful.

Thanks in advance.

[harshnathani]

Hi @Anonymous ,

Check if this helps.

https://community.powerbi.com/t5/Desktop/Dynamically-change-data-source/m-p/581319

https://community.powerbi.com/t5/Desktop/Dynamically-change-data-source-from-SQL-database/m-p/405285

https://community.powerbi.com/t5/Desktop/Dynamically-change-data-source-relative-source-paths/m-p/378219

Regards,

Harsh Nathani