Unanswered

Unable to read data from a query in excel which is stored in onedrive

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have some data which is stored in excel in the form of a table. Before I bring that data to powerapps, I transform it using power query in excel. The resultant is a query that is saved on another sheet autoformatted into a table. Now after I load this table to powerapps, I am getting all the column headers right but the rows are empty.

I tried to pull data from other tables in the same excel file and they all are loading fine. It's just the problem with this power query one. Does Powerapps not allow us to load data from an excel query? Please suggest. Following is the screenshot of the excel file.

Screenshot (361).png

Regards,

Aakash

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

eka24 20,923 on at

Like (0)

Report

Please follow this video from Shane. The excel should be a table and powerapps would assign automatic id column before it works.
https://youtu.be/-Z_13J02RPU?t=192

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @eka24 ,

Thanks for pointing out the Powerapps ID part. I see that even after connecting to excel data in powerapps, the ID column is not generated when I am loading it from the query. So it explains why the rows are not showing. Do you know a workaround this or will I have to give up the idea of loading the data from query?

Regards,
Aakash

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

If want a live connection, then remove the Table connection in Powerapps and restart the process again. Hope your rows are less than 2000. Also Check the file--setting-- if the delegation is increased to 2000.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No