Forum Discussion
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, we manually enter data in a SharePoint list site and that updates the card visuals on the report. For one of these visuals in A, I look at a card visual in report B and enter that in the list. I want to automate this process by linking the visual in A to visual in B. Card visual in A should have the same number as card visual in B. Whenever the number in B changes, the same should happen in A.
One method I tried is using Power BI Datasets option. However, that was not possible due to the fact that I have a live connection to the SharePoint list site. Another method I tried was using Python Selenium where I tried to scrape the number from the visual in report B and entering the data in the SharePoint list but this method was too cumbersome.
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.
1 Reply
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.