Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Link visuals from two different reports

I have two different reports in seperate workspaces. One report we will call A, belongs to our team and which I have editing access to. The other report, B, belongs to another team.    In report A,...
Interesting Links
Need Help
Tips and Tricks
  • edhans's avatar
    edhans
    4 years ago

    You can create a DAX Query using DAX Studio to the first dataset, then in Power BI, create a connection to SQL SErver Analysis Services. The server name would be powerbi://api.powerbi.com/v1.0/Workspace Name, the database the name of the model.

    Then expand the MDX/DAX query area and put in the DAX query. It needs to start with EVALUATE. So 
    EVALUATE
    SUMMARIZECOLUMNS(blah, blah)

    for example. That table will then import to your model, and you can create a quick visual on top of it.

edhans's avatar
edhans
Community Champion
4 years ago

You can create a DAX Query using DAX Studio to the first dataset, then in Power BI, create a connection to SQL SErver Analysis Services. The server name would be powerbi://api.powerbi.com/v1.0/Workspace Name, the database the name of the model.

Then expand the MDX/DAX query area and put in the DAX query. It needs to start with EVALUATE. So 
EVALUATE
SUMMARIZECOLUMNS(blah, blah)

for example. That table will then import to your model, and you can create a quick visual on top of it.