How to set ProviderDataSource for on-premises SQL Server datasources?

[saber35]

Hi all,

I have published a pbix (lets say it sample.pbix) with complete working dataset model (tables and all relationship).  This pbix has an on-premises SQL Server datasource, so I can see "Gateway connection" and "Data source credentials" from the menu "Settings" of the dataset.  I can refresh the data manually from Power BI Service (app.powerbi.com) or even SSMS (SQL Server Management Studio).  

Then, my objective is I want to add partition dynamically, each month.  So I need to add Table.Partition and its data source programmatically using Table Object Models library.  Refer to docs, I already success connected to my sample dataset, and there should be Model.Datasources property so I can reuse it for the new partition.  But I found it empty (for on-premises case).  So how do I add new table partition?  I have tried add partition without set its Source (using class QueryPartitionSource), but still got no luck.

Thanks in advance.

[saber35 · Accepted solution]

Case closed.

For on-premises datasource, build partition using MPartitionSource instead QueryPartitionSource as exemplified by this sample.

Thanks all.