Powershell and semantic model

[Peter_23]

Hi community, I'm trying to figure out if this possible to connect semantic model from powershell?

I mean powershell command to request DAX code: example; var= profit maxx(fact_sales, profit ) return profit

thanks in advance.

[Poojara_D12]

Hi @Peter_23 

Yes, you can use PowerShell to query a semantic model (like a Power BI dataset) via the XMLA endpoint. Use Invoke-ASCmd or a tool like Tabular Editor to send a DAX query and retrieve results.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[Peter_23]

I'm going to try!