Unanswered

SQL Data Not Loading into DataTable

(0) Share

Report

Posted on by JPacella

I have a view that takes 14 seconds to run and results in 278 rows.

When I set this view as the data source for a DataTable, the data table never displays anything. How do I know what's happening under the covers to understand what the problem is?

I have many other aspects of the App that connects to other tables and views without any problem

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report

Run the app in Monitor mode to see what's going on under the hood. 14 seconds feels like a long time to return only 278 rows so you could look at your SQL code for the view and possibly make it more efficient, or add some column indexes or something.

Was this reply helpful? Yes No
Verified answer

JPacella 21 on at

Like (0)

Report

I figured out my issue. This particular view was doing a cross-database join, and the DB User wasn't granted permission on the other DB.

There's always a rational reason for these things.

Was this reply helpful? Yes No