Forum Discussion

SkanderH's avatar
SkanderH
Regular Visitor
2 years ago

Problem when displaying data stored in a column of type 'table'

Hi everybody,

 

I need to create a Data Quality Check dashboard. The idea behind this dashboard is to use it within other dashboards to assess the quality of data feeding into them. Therefore, I need to create a dynamic dashboard that automatically detects the data source of the other dashboards and uses that data source to display Data Quality Check KPIs.
To make the automatic detection of the data sources of the other dashboard, 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?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi SkanderH ,

    Try expanding the data in this table.

     

    Best Regards,
    Wenbin Zhou
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • SkanderH's avatar
      SkanderH
      Regular Visitor

      Hi Anonymous,

      Thank you for your response.

      When I expand the table in Power Query, it appears as shown in the attached photo (Photo 1).
      However, the data doesn't show up in Power BI. (Photo2)