Forum Discussion
Add new table to Direct Query semantic model in Fabric
Microsoft support team has told me is not possible to achieve this.
If you have a PBIX or PBIP file with your semantic model and report, you can open the File in PBI Desktop and the semantic model mode will be Direct Query. However, if you have a fabric architecture where your semantic models should be in a workspace and reports in another workspace and you manage the integration of the reports with Git (you don't publish the reports, you save changes and pull them into Fabric), the connection to the semantic model which is in Direct Query in Fabric, will be a Live Connection from Desktop, so you can't change the model.
I think is a common use case and it should be resolved. For the moment, the only way I've found to solve this is editing the semantic model from VS Code, but it's very difficult to apply changes by code and not by visual interface.
Microsoft support team has told me is not possible to achieve this.
If you have a PBIX or PBIP file with your semantic model and report, you can open the File in PBI Desktop and the semantic model mode will be Direct Query. However, if you have a fabric architecture where your semantic models should be in a workspace and reports in another workspace and you manage the integration of the reports with Git (you don't publish the reports, you save changes and pull them into Fabric), the connection to the semantic model which is in Direct Query in Fabric, will be a Live Connection from Desktop, so you can't change the model.
I think is a common use case and it should be resolved. For the moment, the only way I've found to solve this is editing the semantic model from VS Code, but it's very difficult to apply changes by code and not by visual interface.