Custom visual pull data from multiple fact tables.

absmiths — Tue, 06 Feb 2018 23:09:59 GMT

This may not be possible, but I am looking to pull data from two different fact tables and use them in a custom visual. My model looks something like this:

Dim A

-------

DimAKey

DimAAttribute

Fact A

-------

DimAKey

Measure 1

Fact B

-------

DimAKey

Measure 2

When the user filters on DimAAttribute, I want to be able to pull data from Fact A and Fact B, which both have relationships to Dim A. I know I can just drag the fact measures to the visual, but my question is that the two fact tables have different number of rows, so internally I would like to be able to iterate over them separately. Is it possible to do it that way?

Re: Custom visual pull data from multiple fact tables.

v-viig — Wed, 07 Feb 2018 18:12:04 GMT

That's possible if and only if table are in relationship that can be specified vie Relationship manager of Power BI Desktop.

Otherwise, Power BI will trigger an error.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

topic Custom visual pull data from multiple fact tables. in Developer

Custom visual pull data from multiple fact tables.

Re: Custom visual pull data from multiple fact tables.