Forum Discussion

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago

Connecting to a semantic Model and then importing data

Hello.  I have a semantic model published in a premium workspace. End users are restrcted from modifying this model, but can connect to using a Live Connection, or Direct query when using it as a co...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PPStar ,

After testing, it is not possible to change the storage mode in Live Connection mode itself. If you are switching from Live Connection mode to Direct Query mode, it still won't do the conversion either. You can change the storage mode if you connect directly using Direct Query mode.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago

how can i connect power bi desktop to my semantic model using Direct Query first?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PPStar ,

    Sorry but after my test, you can't connect to semantic model using Direct Query.

    Best Regards,
    Dino Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi PPStar ,

      Sorry I have to correct myself, you can connect to semantic model using Direct Query, but the overall model of your report must be a hybrid model. After testing, you have to connect to excel in import mode before you can connect to semantic model using Direct Query, but even in this case you are still not allowed to change the storage mode!
      Manage DirectQuery connections to a published semantic model - Power BI | Microsoft Learn

      Best Regards,
      Dino Tao