Forum Discussion

Sheikh_Musaib's avatar
Sheikh_Musaib
Frequent Visitor
3 years ago

Dynamic PowerBI Reports

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.

2 Replies

  • 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's avatar
      Sheikh_Musaib
      Frequent Visitor

      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.