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

saber35 — Fri, 18 Nov 2022 14:01:53 GMT

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.

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

saber35 — Sat, 19 Nov 2022 15:34:05 GMT

Case closed.

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

Thanks all.

topic Re: How to set ProviderDataSource for on-premises SQL Server datasources? in Developer

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

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