Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
More of a technical question, but does the PowerBI desktop solution scale with more cores/threads? What about memory speed/size? Does Power BI use GPUs in calculations (especially in Power Query and data refresh)? Dealing with large datasets and looking to see if throwing more resources can improve down time.
Well, yes. Power BI's core technology is SSAS tabular cubes. Power BI Desktop actually runs an instance of SSAS under the hood and SSAS is quite scalable. On the Power Query side, this depends on how big your dataset is. Are we talking 10M, 100M or 1B rows here? But, if it is big enough, then you may need to look at other options such as Direct Query. Also, you should look at Incremental Refresh if it is import mode. Futhermore, you shouldn't be refreshing large datasets from the Desktop anyway really, use the Service.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 37 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |