cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jozsef_braun
New Member

Import mode vs Live Connection recommendation

Hi All,

 

I would like to see your opinions, experience, recommendation on when to go to the bigger paid services, like AAS/SSAS or Power Bi Premium from normal import mode. I know the general answer is "it depends", but I would like to see experiences. I'm curious simply on performance, not the functions that each service can provide in extra
How many users can query a report simultaneously without a huge performance issue on a default PBI service ?
What is the max recommended model size in import mode?

Thanks in advance

Joey

1 ACCEPTED SOLUTION

Exactly. I was making an argument against Live connections in their current incarnation.

 

One more comment on the number of users.  That is largely irrelevant as the actual mechanics of the Power BI Service are very different.  It is much more a question of the available capacity memory and the ability to evict other datasets than how many users access a dataset that is currently loaded in memory.

View solution in original post

5 REPLIES 5
v-xicai
Community Support
Community Support

Hi @jozsef_braun ,

 

Power BI Pro or Power BI Free supports uploading Power BI Desktop (.PBIX) files that are up to 1 GB in size. Power BI Premium supports uploading Power BI Desktop (.PBIX) files that are up to 10 GB in size.

 

If you need to upload PBIX file that is larger than 10 GB, consider to move data from your source to SQL Server, Oracle or SSAS, then use DirectQuery/Live connection.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

lbendlin
Super User III
Super User III

The one big thing that is holding us back is the absence of the unified data model ( it think it was promised for october at MBAS).  Right now as soon as you use a live connection you are dead in the water, unable to blend in your own reference data.

Hi there

If you are importing the data, you can always blend it with your existing dataset.

The same applies for AAS, where you can blend the data within AAS?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Exactly. I was making an argument against Live connections in their current incarnation.

 

One more comment on the number of users.  That is largely irrelevant as the actual mechanics of the Power BI Service are very different.  It is much more a question of the available capacity memory and the ability to evict other datasets than how many users access a dataset that is currently loaded in memory.

View solution in original post

GilbertQ
Super User II
Super User II

Hi there

Even though you alluded to it depends, it does always depend on what you are looking to do with your dataset. This also means how large your dataset is in terms of PBIX size.

I do know that the PBI Service can handle quite a lot of users.

I would recommend testing out your dataset size and concurrent users to see performance.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors