Web published report taking long time to load, Provide me solution!

[Ganesh31]

I created a power bi report using direct query with SQL, and published to Web , when i view web published report it is taking a long time to get load and show me visuals!

[lbendlin · Accepted solution]

Direct Query mode means that every single query for your report visual changes will be sent back to your SQL server for processing. If your service is not powerful enough your users will see the slow user interface you describe.

Consider using import mode.