Forum Discussion
TSQL power bi API in SSMS
Hi djwbaker,
AFAIK, power bi rest API does not include t-SQL operate features.
Perhaps you can try to use SQL connector with an advanced t-sql statement and parametrize with query parameter then you can use rest api to modify them on the power bi service side.Power Query SQL Server connector | Microsoft Docs
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Datasets - Update Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi djwbaker,
AFAIK, power bi rest API does not include t-SQL operate features.
Perhaps you can try to use SQL connector with an advanced t-sql statement and parametrize with query parameter then you can use rest api to modify them on the power bi service side.
Power Query SQL Server connector | Microsoft Docs
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Datasets - Update Parameters - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Regards,
Xiaoxin Sheng