Power BI & Large Dataset: How to improve performance?

[nrk001]

Hi Team,

I'm getting the below error,

Resources Exceeded

This visual has exceeded the available resources. Try filtering to descrease the amount of data displayed.

Please try again later or contact support.

I'm loading close to 100K-200K records to PowerBI from an Azure SQL database.

Have created a VIEW in the source SQL db and the underlying SQL has 3 - 4 table JOINs and then connected PowerBI via DirectQuery to the VIEW. (View is created on top of the Data Model tables on SQL DB; it is a streaming data that is being loaded into data model tables from Azure Streaming Query Jobs)

In Power BI Desktop, have created a table with few Slicers but the data/charts are very slow to load. 
What things I should take into account to ensure data load faster?

Please assist!

Best Regards

[Phil_Seamark]

Hi @nrk001,

I have Power BI Desktop models with several hundred million rows of data.  The key is to make sure you keep your model efficient.

Only load columns you absolutely need.

Make sure you have your columns typed correctly.

Convert Datetime to Date (in the query editor or before PBI).

Also, watch this video, it's 100% applicable to Power BI.  https://www.youtube.com/watch?v=dgzJPQ2-F5s