Data in Preview But No Data Loads in Model

[PowerBiNinja84]

I have this weird issue with data I'm getting via API. 

The data loads in the query editor:

But when I close and apply, my data table is empty.

Any ideas what might be going on?

Thank you

[simone000000000]

Hi,

I think I am having the same issue. Did someone find a solution in the menanwhile?

Thank you very much

[themistoklis]

@PowerBiNinja84 

Simply Click 'Refresh' again on Desktop and not on 'Power Query" editor and hopefully this should do the trick

[VijayP]

@PowerBiNinja84 

Its related to Desktop Memory. It some times happens with simple imported Data. Just Refresh / Close and open the file

it shoud work! Please Share Kudoes Thanks

[PowerBiNinja84]

thank you for the reply. I've closed the file, restarted the machine, manually refreshed, and the data fails to load in the model, while still visible in the preview. 

[v-yiruan-msft]

Hi @PowerBiNinja84 ,

Please review the methods in the following threads and hope they can help you resolve the problem.

Data Not Showing Up

Data Loading Fine in Power Query but not Loading in Power BI

Best Regards

Rena