Data Quality Check Dashboard connects to another Dashboard data source

[SkanderH]

Hello everyone,

I need to create a Data Quality Check dashboard that connects to data from another dashboard and displays within that dashboard. For example, in my Financial dashboard, I want to incorporate my Data Quality Check dashboard to show data quality KPIs based on the data source used in the Financial dashboard.

[Anonymous · Accepted solution]

Hi @SkanderH ,

// I need to create a Data Quality Check dashboard that connects to data from another dashboard and displays within that dashboard.
The Dashboard can get data from multiple semantic models. What you may need to do is first connect to these semantic models, create a pair of visualizations, then publish to the PowerBI service, and later pin the visualizations to the dashboard.
Note that the connection mode needs to be converted to DirectQuery when connecting multiple semantic models.

DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[SkanderH]

Hi @Anonymous 
I tried to gather all data sources into a table named 'Dupliquer_les_données_du_Dashboard'.
Here is its M code to generate the table 'Dupliquer_les_données_du_Dashboard'. (See screenshot 1)
So, this table consists of 2 columns:
• 'Name' (where the source name is listed).
• 'DuplicatedTable' (which is of table type, containing the source data table).

In Power Query, when we click in the cell of 'DuplicatedTable' we can see preview the data stocked in that cell (See screenshot 2)
When I click on 'Apply & Close', this is the result that i get in Power BI (I can't acces the data). (See screenshot 3)

How can I access this data to create DAX formulas for KPIs?

[Anonymous]

Hi @SkanderH ,

You need to further deepen out the table in PowerQuery. (In the second image click on 'Table' to deepen.)

Otherwise all that loads to the desktop is the text value "Table".

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group