Reply
Peter_23
Advocate II
Advocate II

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.

2 REPLIES 2
Poojara_D12
Memorable Member
Memorable Member

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 

I'm going to try!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)