cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SarCen
New Member

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.

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors