Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ganesh31
Frequent Visitor

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

‎02-19-2023 08:02 PM

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!

 

Screenshot 2023-02-20 092435.png

Labels:
Message 1 of 2
340 Views
0
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

‎02-20-2023 10:52 AM

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.

View solution in original post

Message 2 of 2
289 Views
1 REPLY 1
lbendlin
Super User
Super User

‎02-20-2023 10:52 AM

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.

Message 2 of 2
290 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All