Hi ,
How to we add tables created during runtime to data model in Power Bi in direct query mode .
For eg:-
Table A1 , A2, A3, A4 … An could be created during runtime in source data , the same newly created tables should be created in power BI (power pivot) data model and after the new table is created for eg A2 is created in source data then that should be visible in power bi data model and all relations which table A1 has with other tables same relationships A2 should have with all other tables and A1 does not have any relation with A2 . And data connection mode is direct query mode.