Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I work for a multi-company group and all of the companies have a data gateway that I have access to. Is there any way for me to create a report that would consolidate those different sources that are not accessible from my computer?
I have access to remote computers for all of those sources.
Thank you,
Solved! Go to Solution.
I have access to a SQL database for one company on my personal computer and I need to go through a remote desktop to access another SQL database. Both have a gateway already setup, but I can't create a report with both database because I need to have access to both on PowerBI desktop.
I would like to have something for each company like "Division | GL | Amount" and append them all to make a report out of it.
User | Count |
---|---|
34 | |
21 | |
20 | |
14 | |
12 |
User | Count |
---|---|
26 | |
18 | |
18 | |
17 | |
14 |