Dynamic PowerBI Reports

[Sheikh_Musaib]

Hii, 

        Is there any way to let PowerBI do everything dynamically?

                    By dynamically, I mean if any new table gets added from the SQL side, it should be automatically imported in PowerBI and also should auto-detect the relationship. Similarly, if any existing table gets deleted in SQL, it should automatically get deleted in PowerBI, instead of showing an error.

[FreemanZ]

Typically, to reflect the change from the data source, one needs to refresh the report on Power BI Desktop app or Power BI service.

[Sheikh_Musaib]

Thank you for the reply

               But refreshing the report on PowerBI Desktop will refresh the data of existing tables present in PowerBI only. But what my requirement is if any new table gets added in SQL, it should be automatically imported in PowerBI.