Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
martynhale
Frequent Visitor

PowerBi Desktop or PowerBI Service

I'm about to start a new project for a client. The data source will be an on premise 2008 SQL server.

 

I'm not fully sure whether to start the development from within PowerBI desktop and then publish to PowerBI service, or to start within PowerBI service. Does PBI Service have the same level of functionality as PBI Desktop?

 

Regards,

Martyn

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

Hi martynhale,

Adding to ankitpatira’s post , you can connect directly to SQL Server Analysis Services Tabular model databases from Power BI service and create reports. In this case, Power BI Enterprise Gateway is required. For more details, please review this article.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ankitpatira
Community Champion
Community Champion

@martynhale You should strat with powerbi desktop and then publish to powerbi service. Unfortunately in powerbi service you don't get data modelling functionality which is only available in powerbi desktop.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.