Power Platform Community Forum Thread Details

Hello everyone

I have a powerapp which has an excel (onedrive for business) data source. The excel file has 3 data queries which i update daily to refresh the data in the excel file.

However, when i refresh the data sources from PowerApps, i find that the excel tables are no longer linked to the queries.

I can refresh all queries and they run just fine, however the data will not longer load to the tables.

When i go into the Name Manager the 3 queries are added called ExternalData_1 or 2 etc.

For example:

I want to know what incidents have been entered into the incident management system for the previous day. I have a query that extracts all incidents entered the previous day and it loads to 'DailyIncidents' Table.

I then connect the file and table as a data source in PowerApps and the data flows through fine. However if i go back into excel, i find that the 'DailyIncidents' table is no longer connected to the 'DailyIncidents' query (if i right click in the table the 'refresh' option is greyed out).

If i double click on the query and go into the query editor i can see that the query is running and updating, just not loading to the 'DailyIncidents' table. To fix this, I have to delete the 'DailyIncidents' table and have the query re load to the same position before i save it down.

Any ideas why this is happening and how i can avoid it?

Thanks

Barry

Categories:

Building Power Apps