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.
