Forum Discussion

ats1958's avatar
ats1958
Helper II
8 years ago

Changing Data Source / SQL Query via API

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.

Need Help

1 Reply

Replies have been turned off for this discussion
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards