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.

pankajnamekar25's avatar
pankajnamekar25
Super User
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.

  • lg01's avatar
    lg01
    Advocate III
    1 year ago

    Thank you for the feedback. There is an option for "SQL Server Analysis Services database" that allows for DAX queries and import the data. Is that the equivalent of the first option you are describing?

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi lg01 ,
      Thank you for the accurate response pankajnamekar25 !

      Yes, the "SQL Server Analysis Services" connector in Power BI Desktop connects to the XMLA endpoint, which is exactly what Pankaj mentioned earlier. It lets you send DAX queries to the semantic model and import only the data you need just like querying an Analysis Services database.

      You may need XMLA read permissions and a Premium or PPU workspace to use it this way.Refer the link for more information:https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools 

      Happy to help you!
      Thank you.

      Regards,
      Pallavi.