Forum Discussion

DavidPi's avatar
DavidPi
Advocate II
9 months ago
Solved

Web modeling - import data from MS Fabric Warehouse

Hello, I want to create semantic model with MS Fabric Warehouse views and on-prem tables from Oracle DB. Is it possible to create semantic model on the web and import views from Fabric warehouse (not DirectLake or DirectQuery but Import mode) and then add Oracle tables via GTW connection (also Import mode)? I am not able to find this. Thank you.

Need Help
  • tayloramy's avatar
    tayloramy
    9 months ago

    Hi DavidPi, 

     

    I don't think this is possible in the web edit. The web edit doesn't allow for composite models to my knowledge, and doesn't allow creating gateway connections to on prem data. 

    First you would need a process, either a pipeline or dataflow gen 2, to move the data from on prem into the warehouse, and then from there you can create a semantic model in Power BI Desktop in import mode. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

3 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    9 months ago

    Hi DavidPi   You can build a semantic model on Fabric Warehouse tables or views, but the web modeling interface doesn’t yet support mixing Fabric sources with on-prem data (like Oracle via Gateway) in the same model. For hybrid Import-mode scenarios, you’ll need to use Power BI Desktop, connect to the Warehouse SQL endpoint and your Oracle source, then publish the model to Fabric.

     

    Ref: https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models

     

  • tayloramy's avatar
    tayloramy
    Super User
    9 months ago

    Hi DavidPi, 

     

    I don't think this is possible in the web edit. The web edit doesn't allow for composite models to my knowledge, and doesn't allow creating gateway connections to on prem data. 

    First you would need a process, either a pipeline or dataflow gen 2, to move the data from on prem into the warehouse, and then from there you can create a semantic model in Power BI Desktop in import mode. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    9 months ago

    Hi DavidPi 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


    Thank you.