Forum Discussion

Hitu's avatar
Hitu
Frequent Visitor
1 year ago
Solved

Semantic data model in Power BI service using direct query mode

Hi Team,   Is it possible to create semantic data model in Power BI service using direct query mode starting from scratch?
Need Help
  • jaineshp's avatar
    jaineshp
    1 year ago

    Hey Hitu,

    Unfortunately, creating DirectQuery semantic models directly in Power BI Service isn't supported currently.

    • Service requires Desktop for initial DirectQuery model creation
    • Amazon Athena connector needs Desktop setup first
    • No workaround exists for pure Service-based creation

    Fixed? ✓ Mark it • Share it • Help others!


    Best Regards,
    Jainesh Poojara | Power BI Developer

  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Hitu ,

    I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

    Thank you.

Hitu's avatar
Hitu
Frequent Visitor
1 year ago

Hi jaineshp 

Thanking you for your quick response.You have mention creating the semantic model in Power BI desktop , but here i am looking for option to create the semantic model with direct query mode connecting to Amazon Athena in Power BI service  and without using Power BI desktop.

jaineshp's avatar
jaineshp
Icon for Memorable Member rankMemorable Member
1 year ago

Hey Hitu,

Unfortunately, creating DirectQuery semantic models directly in Power BI Service isn't supported currently.

  • Service requires Desktop for initial DirectQuery model creation
  • Amazon Athena connector needs Desktop setup first
  • No workaround exists for pure Service-based creation

Fixed? ✓ Mark it • Share it • Help others!


Best Regards,
Jainesh Poojara | Power BI Developer

  • Hitu's avatar
    Hitu
    Frequent Visitor
    1 year ago

    jaineshp 
    Thanking you for the confirmation. Much appreciated