Forum Discussion
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
- SkanderHRegular Visitor
Please guys someone help me !
- AnonymousNot 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.- SkanderHRegular 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)