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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rgparisoto
Helper I
Helper I

SQL Server or Analysis Server?

Mornin' friends!

 

Have you some oppinion about the best connection between SQL Server or Analysis Server?

 

I'm changing all the structure of my Power BI, and the momment to do the right thing is now.

 

Any idea will be very appreciated.

 

Regards,

 

Robson Parisoto.

3 REPLIES 3
v-sihou-msft
Employee
Employee

@rgparisoto

 

It depends on your usage, and data.

 

For better structure of your data, I suggest you use Analysis Services databse. Power BI actually host a temporary Tabular model database at backend for each opened .pbix file. So all the underlying objects of a Power BI data model is just same as Tabular model. You can just do evertthing within a Tabular project and connect live to the Tabular model in Power BI Desktop. 

 

But if you need to do data transform, or have a lot of work in Query Editor. You may still SQL Server. Because you can't do anything modeling except creating measures when opening live connection to SSAS database. 

 

Regards,

Hi @v-sihou-msft!

 

Do you know if it's necessary to have a 2012 or latest version of SQL Server?

@rgparisoto

 

I suggest you try SQL 2016.

 

Regards,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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