Forum Discussion

DavidPi's avatar
DavidPi
Icon for Advocate II rankAdvocate 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...
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.

tayloramy's avatar
tayloramy
Icon for Super User rankSuper 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.