Forum Discussion

Helper II

10 months ago

Solved

Designing Reports with Multiple Fact Tables

Greetings. A client wants to have multiple reports that use different fact tables. They would like to go into a single spot and click on different pages. Some pages use different fact tables. Fo...

Tips and Tricks

djurecic
10 months ago
Hi callenbkd ,

Yes, apps are a great way to combine multiple reports. There are 2 type of apps, workspace apps and org apps.

Here is more information about each of them:

https://community.fabric.microsoft.com/t5/Fabric-platform-Community-Blog/Org-apps-vs-Workspace-apps-for-Fabric-and-Power-BI/ba-p/4663708

https://databear.com/power-bi-org-app-vs-workspace-app/

Super User

10 months ago

As long as your fact tables are controlled by common dimension tables you should be fine. Your slicers and filters need to always come from the dimension tables. Do not join fact tables to each other.