Extending a Semantic Model

Hi  ddelapasse,

Thank you for reaching out to the Microsoft Fabric Community.

I understand that your Azure SQL database is behind a VPN and accessible through the Power BI Service via a gateway, which prevents users from directly modifying the dataset. Additionally, your users need to combine this data with their own datasets, but they are unable to use Power BI Desktop due to network restrictions. 

I also appreciate the insights shared by Greg_Deckler ,in this discussion. 

• You can create a dataflow in Power BI Service that imports data from Azure SQL (via the gateway) and another dataflow that loads user-provided data from sources like SharePoint or OneDrive. These dataflows can be combined to form a single dataset, enabling users to build reports without the need for Power BI Desktop. 
• Users can upload their datasets (Excel, CSV, etc.) to OneDrive or SharePoint. You can then create a new semantic model in Power BI that integrates their data with Azure SQL. Please note that users will need to update their files as necessary.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.