Data Upload

[Aboffine]

Please, I need Help. I am a new user and i have successfully uploaded my data from excel. although the data in the table appeared in the report area before i clicked load, the table is empty when I click on table view and the columns do not appear in the data pane to the right. How can I resolve this please. 

[Aboffine]

These are pictures of my screenmy dataafter I load dataTable view with no data showing

[Greg_Deckler]

@Aboffine On the last screen shot, just below the bar where you cut it off, how many rows does it say are loaded?

[Aboffine]

Hi Greg, Thanks for replying! It says 1,048,419 rows. 

[v-xinruzhu-msft]

Hi,

Thanks for the solution @Greg_Deckler  provided, and i want to offer some more information for user to refer to.

hello @Aboffine , based on your description, you have 1,048,419 rows, the dataset is large, so it causes slow loading, you need to reduce the size to improvement the performance, you can refer to the following link about how to optimize.

Optimization guide for Power BI - Power BI | Microsoft Learn

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.