Forum Discussion
Helper IIIDo i need Power BI Premium Capacity is needed while we are connecting to Snowflake
Hi Friends,
My source is SnowFlake Views.
I am connecting multiple views in power bi desktop. As of now using Import mode. We are building a model from scratch.
I have uploded report to Workspace and Provided data connecting using snowflake service User and Password.
Now if our organisation data grows do we need any Premium capacity ?
What if we opt Direct Mode?
Since Snowflake is Cloud DB Do we really need Premium capacity?
Please help me in this.
Regards,
I am using PPU Licensce.
Ciao Gopal_PV ,
here the answers:
Now if our organisation data grows do we need any Premium capacity ?
Answer: not until when your semantic model reached 100 Gbytes if you are using a PPU Workspace (therefore all the people you share with need the same license) or 1 GByte if you use a Pro Workspace (meaning that other people with which you share the workspace pay only a pro license, you can keep your PPU)
What if we opt Direct Mode?
Answer: in that case there is no import so no memory resources involved, so no size limit. BUT performances are much worse than Import mode (and depened heavily on the server that answers you and on the SQL database architecture)
Since Snowflake is Cloud DB Do we really need Premium capacity?
Answer: since it is a cloud DB you will not need a gateway for the refresh but yes if the data you import exceed the above mentioned limits, you will need a premium capacity
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
2 Replies
- FBergamaschi
Super User
Ciao Gopal_PV ,
here the answers:
Now if our organisation data grows do we need any Premium capacity ?
Answer: not until when your semantic model reached 100 Gbytes if you are using a PPU Workspace (therefore all the people you share with need the same license) or 1 GByte if you use a Pro Workspace (meaning that other people with which you share the workspace pay only a pro license, you can keep your PPU)
What if we opt Direct Mode?
Answer: in that case there is no import so no memory resources involved, so no size limit. BUT performances are much worse than Import mode (and depened heavily on the server that answers you and on the SQL database architecture)
Since Snowflake is Cloud DB Do we really need Premium capacity?
Answer: since it is a cloud DB you will not need a gateway for the refresh but yes if the data you import exceed the above mentioned limits, you will need a premium capacity
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
v-ssriganeshCommunity Support
Hi Gopal_PV,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to FBergamaschi for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.