Forum Discussion
PowerBI Limitations
KALAKUNTLAS , These are limits for visual -
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-sampling
Performance is a function of the model, data size, and hardware. A star schema with all numeric keys would be the fastest. Thin tables without unnecessary columns and rows would be another way to improve performance.
You need to choose premium hardware based on data. Also, use aggregated tables were needed to improve performance.
Community SupportHi, KALAKUNTLAS
1. Purchasing a premium license doesn't change the limits of visual, and the limit you can see in the link shared by amit.
2. It depends on the connection mode. For Direct Query, you can returns 1 million rows maximum. For details you can check this link:
Solved: how many rows can power bi handle - Microsoft Power BI Community
3. Owning premium can make lagre datesets have better performance in service.
I don't know about Tableau, but Powerbi is better than Tableau in data analysis and data modeling. It's up to you to choose.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey