I would like to understand how FLATTEN feature work. While connecting to Power BI it should be put like that?
Then thanks to that I can work with nested tables from Data Lake without the need to make them flat?
![Michael_Soprano_0-1725350428137.png Michael_Soprano_0-1725350428137.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/79631iB7A4E32C095DB87A/image-size/medium?v=v2&px=400)
The other solution which I think about is flattening the Data Lake tables using the Query Service, putting them in Accelerated Store and then they are useable by Power BI. Is it correct way of thinking?