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 ,
I hope the suggested solution worked for you. If you found any workaround,please share it the community and accept your answer as solution.It will be helpful for others who are facing similar issue.If it is not resolved, please feel free to reach out!
Thank you.