topic Re: Changing Data Source / SQL Query via API in Developer

Changing Data Source / SQL Query via API

ats1958 — Mon, 05 Feb 2018 17:29:10 GMT

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.

Re: Changing Data Source / SQL Query via API

v-ljerr-msft — Wed, 07 Feb 2018 08:53:55 GMT

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