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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi lg01 ,
Following up to check whether you got a chance to review the suggestion given.If still facing any issue,feel free to reach out!
Thank you.