How to add dyanamic tables created in source data to data model in power BI in direct query mode

[PBI_123]

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.

[PBI_123]

Many Thanks Liu.

[Anonymous · Accepted solution]

Hi  @PBI_123 ,

As far as I know, Power BI refreshes the information of the table that already exists currently, if your table was created after the report was loaded and only exists in the data source and not in Power BI, then you need to reuse Power BI to connect to the data source to get the new table that was created, and then finally to connect the relationship between the two tables in the Model View

Refer to:
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Liu Yang

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