Forum Discussion
Query existing semantic model
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
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
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
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
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?