Forum Discussion

ldwf's avatar
ldwf
Helper V
2 months ago
Solved

Converting to Direct Query from Import to integrate with Power Apps and Fabric

I have a PBI dashboard built by connecting to published semantic model.  The storage mode is import.  I need to integrate this dashboard with a table in Fabric as well with a Power App form.  I can't...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    2 months ago

    ldwf 

     

    Fix: turn the live connection into a composite model. That unlocks adding your Fabric table and keeps your dashboard intact.

     

    If this answer helped, please click 👍 or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande

Natarajan_M's avatar
Natarajan_M
Super User
2 months ago

Hi ldwf : 

when you connect to the already published semantic model it will be in the live mode


If you need to add new tables then it will become composite model 

e.g. go to get data -> semantic model  
you will get the below prompt "Add a Local Model"




Once you select the tables to include in the local model and add the second source then the connection will become direct query 




this is how it will look in the model view :


Connecting Fabric server

 

added a table :


The storage mode will be direct query and the model in technical terms called as "Composite model"

Check the compatability level :


also the tmdl view should be visible to you 

 



Thanks!

Natarajan Manivasagan

If you found this helpful, please consider giving it a Kudos and marking it as the accepted solution — it goes a long way in helping others facing the same issue.

 

🏆Best Solution for Enterprise BI — 2026 Microsoft Fabric Semantic Link Developer Experience Challenge
👉Microsoft announcement · View the winning notebook

 

For more Power BI tips and discussions, let's connect on LinkedIn.

 

Cheers!