Forum Discussion
Load data from selected folder
Hi Anonymous,
Currently, you can't use 'data view' filters to affect the backend query tables. They are working on different levels. (data model tables are generated from query tables, you can't use child level to affect its parent)
Did these folder files have the same data structures? If that is the case, you can create a query parameter to parameterize the 'folder path' in your data connector. Then you can edit the query parameter in the data view to change underlying data sources.
Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Parameters - Power Query | Microsoft Docs
Regards,
Xiaoxin Sheng