Beginner to Power BI—Trying to Combine Multiple Dashboards into one

[DashBoardDiva]

Hi there! I'm new to Power BI and have a few questions that I’ve been struggling to find clear answers for.

I recently completed the Power BI course from Maven Analytics, so I have a basic understanding of the platform. I work as an Executive Assistant in an executive office, and while Power BI isn't part of my official role, it's a skill I really want to develop.

I support three different teams, each of which has its own dashboard. My boss would like to combine specific information from each of these dashboards into a single, consolidated report. However, I don’t have a Fabric license, and based on what I learned in the course, it seems like one is required to set up things like dataflows or shared workspaces—which would make managing the data sources a lot easier. Unfortunately, since I don’t have that license, that option is off the table for now.

As a workaround, one of the teams shared a synced folder with me that contains their Excel-based data source, which I could use. The idea would be to manually rebuild everything—tables, relationships, DAX calculations—for each report. This is my very first report, and I’m feeling a bit overwhelmed and unsure where to begin.

Any advice or insight would be greatly appreciated! (Please be gentle on me; I'm still learning)

[v-pbandela-msft]

Hi @DashBoardDiva,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @DashBoardDiva,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @DashBoardDiva,

Thank you for reaching out in Microsoft Community Forum.

Thank you  @lbendlin  for the helpful responses.

As suggested by Ibendlin,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[lbendlin · Accepted solution]

Having a shared folder is a great start. It would be even better if that would be a SharePoint folder  (or folders) as that would include automatic versioning - something you will value when you need to restore prior versions of files and reports .

Fabric is not a license, it is a capacity that you purchase on a consumption base or through reservations.  It won't help you without a Pro license.  Depending on the size of your audience you can go with a Fabric capacity and only a few Pro licenses for the developers, or you can go without a Fabric capacity but with Pro licenses for all users.

You may want to find a Microsoft partner near you who can take you through the sizing and pricing options.

[DashBoardDiva]

Once the files are placed in a shared folder, what would you suggest as the next step?

[lutz_bendlin]

use the SharePoint Folder connector to ingest these files into your semantic model(s).