Forum Discussion

PBI_123's avatar
PBI_123
Regular Visitor
2 years ago
Solved

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

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 ne...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.