Forum Discussion
Using PowerShell to get PowerBI SQL connection strings
Hi aWalsh523,
AFAIk, current you can't directly get the advanced SQL statement from the data connector by rest API.
It should be more suitable to trace these on the database side or you can consider parameterized t-sql string with query parameters, then you can use the rest API to get query parameters to get detailed t-sql queries.Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
let source=Sql.Database("server", "database",[Query=SQLParameter]) in sourceDatasets - Get Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi aWalsh523,
AFAIk, current you can't directly get the advanced SQL statement from the data connector by rest API.
It should be more suitable to trace these on the database side or you can consider parameterized t-sql string with query parameters, then you can use the rest API to get query parameters to get detailed t-sql queries.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
let
source=Sql.Database("server", "database",[Query=SQLParameter])
in
sourceDatasets - Get Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Regards,
Xiaoxin Sheng