Push Dataset with Datasource

Thanks for all the suggestions. However, push datasets API does not allow for the datasource change.

"With a push dataset, data is pushed into the Power BI service. When the dataset is created, the Power BI service automatically creates a new database in the service to store the data". Real-time streaming in Power BI - Power BI | Microsoft Docs

Importanly, you can not override or change the database that is created by the service. My use case does not fit using a push API. Another suggestion was using XMLA endpoint to programmatically create datasets. I have not explored that suggestion. However, now I understand how push dataset work even if the API documentation is misleading. The existing of the datasource object in the documentation would lead one to believe it can be used, but alas that is not the case currently.