Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
We have Multidimensionsal solution with multiple cubes in Databse. We have setup linked server to database programtically query the data. Can some one please tell how to specify the Cube Name while querying the Table using DAX. We want to use same LinkedServer Connection to query data from Muliple Cubes
Example:
select * from openquery(LinkedServerName,''EVALUATE CubeName.Table''))
If we specify the Cube Name then it's not working . With MDX , we have option to specify the Cube Name ( From Clause) while with DAX we didn't find option.
Please tell how to provide the Cube Name while querying from DAX
Thanks,
Abhiram
Hi @abhiram342 ,
Please share some sample data so that we could test formula.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |