Forum Discussion

darrellkilian's avatar
darrellkilian
Regular Visitor
8 months ago
Solved

Ability to create a DirectQuery in a semantic model created/edited online in Power BI Service

Creating semantic models online in Power BI Service is a big step forward and enables easier ways to collaborate, and manage versions/source. And no publishing step. Also, no local installs and updat...
Need Help
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii darrellkilian 

     

    DirectQuery cannot be created or enabled yet in semantic models that are built or edited directly in Power BI Service. Online modeling currently supports only Import mode, so if you need DirectQuery, the model still has to be created in Power BI Desktop first and then published. Microsoft has stated that DirectQuery for online semantic models is planned, but not available today.

ChielFaber's avatar
ChielFaber
Icon for Super User rankSuper User
8 months ago

Unfortunately, as rohit1991 mentioned, DirectQuery isn’t supported yet when creating a semantic model directly in the Power BI Service.

 

If your goal is to stay fully in the online authoring experience and work in a DirectQuery-style architecture, then Direct Lake is the closest—and in many cases better—alternative. With a Fabric license, you can create and model everything directly in the Service, without Desktop and without losing real-time capabilities. Direct Lake is also designed to outperform classic DirectQuery on larger datasets.

If you haven’t explored it yet, it’s definitely worth a look:
https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-develop