Forum Discussion
Peter_23
1 year agoAdvocate V
Powershell and semantic model
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 ) retur...
Poojara_D12
1 year agoSuper User
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_231 year agoAdvocate V
I'm going to try!