Hi @DM_110 ,
2 things to do,
1.) Create a new screen insert a new gallery and point the gallery to the source data, lets see if any data shows.
2.) on the new screen, insert a button -> then on the "onselect" button adding the following ClearCollect(TestConnection, your sourcedata)
Then ALT left click on the button, give 10 secounds then go to File -> Collections -> look for TestCollection -> select it and see if you see records(data).
Edited: Its possible that excel documents could be misbehaving like cwebb365 mentioned.
Last note, Also dont duplicate the documents, Do a plan text(no table formats) copy and paste into a new excel document. Then format the data back into a table.
Have a great holiday.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand