Forum Discussion

Peter_23's avatar
Peter_23
Advocate V
1 year ago

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 ) return profit

 

thanks in advance.

General Comment
Interesting Links
Show and Tell
Tutorial Requests

2 Replies

  • Poojara_D12's avatar
    Poojara_D12
    Super User
    1 year ago

    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