Creating a Relationship between Multiple Data Sources

[CameronP]

Hi there,

I'm in charge of creating a dashboard for my work which requires data from a number of different sources.

I've attached a picture:
https://imgur.com/s945kXm

The budget and Appended Non-Salary is my data and the other two files are libraries.

The visuals I'm trying to create need to be sorted by Branch and by Fund (done through a relationship between my Branch Library (AlternateLibrary) and Fund Library.

I'm wondering if there is a way to create visuals with multiple data sources sorted by both branches and funds.

Thanks,
Cam

[Anonymous]

HI @CameronP,

You can import multiple datasource with import mode and create relationship between them. If you use direct query or live connection, it is impossible to create report with multiple data sources.

Regards,

Xiaoxin Sheng

[CameronP]

Hi Xiaoxin,

I don't have a problem importing multiple data sources or creating relationships with them- it's when I need to create two libraries attached to multiple data sources. As I need a filter for both fund and by branch (see the link).

Thanks for the response:)

[CameronP]

bump