“When I modify a data source to add some new field (table), it won’t show up when I refresh my queries in Power BI”

If that happens, we recommend reconnecting to Power BI to add new tables. In Navigator, you can select only newly added tables to the existing model.