semantic models: ways to connect to it other than PBI (Azure SQL, ADF,etc) How else can I query it?

Hi sasdfasdfsad, 

Then I'd recommend trying the DAX API, the Semantic Link library in a notebook, or the XMLA endpoint. 

If you have PowerAutomate premium licenses, you can also try PowerAutomate like GeraldGEmerick suggested, that would be the most user friendly way to do it if it can achieve your needs. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

Hi sasdfasdfsad,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to tayloramy, GeraldGEmerick, for those inputs on this thread.

You cannot connect Azure SQL directly to a Power BI semantic model, but you can query it using the Power BI REST API (executeQueries) and load the results into Azure SQL via Azure Data Factory for the simplest, supported pattern. If you are on Premium/Fabric, you can also use the XMLA endpoint or export tables to One Lake (Delta).

Refer these links:
1. Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn
2. Semantic model connectivity and management with the XMLA endpoint in Power BI - Microsoft Fabric | Microsoft Learn
3. Power BI Semantic Models - Microsoft Fabric | Microsoft Learn
4. Web Activity - Azure Data Factory & Azure Synapse | Microsoft Learn

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.