Forum Discussion
Semantic data model in Power BI service using direct query mode
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
Memorable MemberHey Hitu,
Yes, creating a semantic data model in Power BI Service using DirectQuery mode from scratch is definitely possible.
Power BI Desktop:
- Start with Power BI Desktop and create your DirectQuery semantic model there first
- Go to Home → Get Data and select your data source (SQL Server, Oracle, etc.)
- In the connection dialog, under Data Connectivity mode, select DirectQuery Microsoft LearnGitHub
- Build your data model, relationships, and measures in Desktop
- Publish the .pbix file to Power BI Service to create the semantic model
- Once published, the semantic model will maintain DirectQuery mode in the service
Hope this helps clarify the approach.
Fixed? ✓ Mark it • Share it • Help others!
Best Regards,
Jainesh Poojara | Power BI Developer
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
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