Partial Refresh or Load for several Table only

[TotalAnonymous]

Dear community,

I hope you're doing well. Currently, I have a project creating a report based on SharePoint List dataset. Actually, it's part of collaboration with Power App developer. The scenario is user will fill the related data using Power Apps, then the data will be stored in SharePoint list, and the PBI report will pull the dataset from the sharepoint. However, there are several lists that are important in my visual but they haven't filled yet by the user. My question is have you ever handling the same project? the project where you create the report first then the data itself will be filled instead of having the dataset in our SharePoint List then create the report. 
Because, the challenge is when the several lists still 0, Power Query can't detect any columns in that list. But once the data come into the lists, the columns will be detected and my Power Query step will be running smoothly.

Any suggestion will be appreciated. Thank you!

[amitchandak]

@TotalAnonymous , You need to have columns once from the list. If we want to create any structure that is not available, I might use Excel for sample data. Then later you need to change the source. Better get some test data and create it.

[TotalAnonymous]

Hi @amitchandak , thanks for your reply! before the app launch, I've created the report using the test data in our SharePoint list. Since app have been lauched yesterday, all the test data will be removed. It means all lists will be 0 record. Now, after the launch, let's say, we have list A, B, C, and D have been fulfilled by user. Meanwhile it, the other lists, which are E and F haven't been fulfilled and the record still 0. Since I need the data that comes from those lists, it means it's best for me to wait until data in E and F does exist right? Because, if they're still 0 record, the dataset refresh process will face an expected error.

Thanks