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,
Power BI data models are not conventional SQL database tables, and rather Analysis Services (Tabular) models. As such, T-SQL is not a valid way to query them, whereas MDX/DAX/XMLA are all appropriate languages suitable for doing this. As such SSMS will not enable T-SQL here, but enable the others, as you're experiencing.
Regards,
Daniel