When using search in PowerQuery in service (LakeHouse) it does not load items

[PLangeler]

When using search bar in a Dataflow Gen2 connecting to a LakeHouse the entities or tables are not loaded. If you use navigation it does. Perhaps the search is also applied on tables, why elements are not showing.

[v-yueyunzh-msft · Accepted solution]

Hi ,  @PLangeler 

According to your description, when you search the table in LakeHouse in the search box in DataFlow Gen2, the corresponding item is not loaded:

I test it in my side , My situation is the same as yours. I have tested some situations. Currently, this search box only supports the data loaded on your interface. The front end only caches the data after your visit. If you just entered this page, you can only search what you can See the item. Therefore, if you want to directly search for a table under a certain lakehouse, you can try to locate and load all the table information under this lakehouse first, and then use the search box to search.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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