Changing Data Source / SQL Query via API

[ats1958]

I'm embedding a report that's connected to an Azure SQL Database. Is there a way to programmatically change the initial SQL statement? Specifically, I'd like to change the WHERE clause to reference a specific username.

[v-ljerr-msft]

Hi @ats1958,

I don't think there is a way to programmatically change the initial SQL statement of a data source currently. You can add it as an idea on Power BI Ideas forum to improve Power BI on this feature. 

Regards