Forum Discussion

lg01's avatar
lg01
Advocate III
1 year ago
Solved

Query existing semantic model

There is a semantic model our IT department published and I need some data from it. However, I don't need to upload all the table into my report as it is transactions and it has high volume. I read a...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello lg01 

     

    try these options

    Use XMLA Endpoint + DAX Studio / SSMS

    Connect using: powerbi://api.powerbi.com/v1.0/myorg/<WorkspaceName>

    Run DAX queries like

    EVALUATE FILTER('Sales', 'Sales'[Date] >= DATE(2023,1,1))

    Export filtered results to CSV/Excel.

    DirectQuery to Power BI Dataset

    In Power BI Desktop: Home > Get Data > Power BI Datasets

    Live connection; no data import.

     DAX Query Tables (Hybrid)

    Create custom table using filtered DAX query:

    FilteredSales = FILTER('Sales', 'Sales'[Date] >= DATE(2023,1,1))

    Requirement: Premium or PPU workspace + XMLA read access.

     

     

     

    Thanks

     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

rohit1991's avatar
rohit1991
Super User
1 year ago

Hi lg01 

 

Yes, you can efficiently query specific data from a published Power BI semantic model using the XMLA endpoint. This is exactly the scenario where XMLA shines, especially when you only need a filtered subset of data (like the last two years) without importing an entire table into your report.

 

Could you please try below steps:

  1. Get the XMLA endpoint URL from your Power BI workspace settings (Premium or PPU is required).
  2. Connect using “SQL Server Analysis Services” in Power BI Desktop, DAX Studio, or SSMS.
  3. Run a DAX query like:
DAX Code = EVALUATE FILTER('Sales', 'Sales'[Date] >= DATE(2023,1,1))


You can export the results to Excel/CSV or even use them in a live Power BI dataset (Live Connection, no data      import needed). You’ll need your admin to enable it, or consider other options like Dataflows (though those require some extra setup and don’t offer the same flexibility).