Data available in power query editor but not loading to model

[jdwalker5]

Hello,

I recently ran into an issue with one of my reports where data was missing from the model, but was clearly available when I opened query editor.  I was trying to view data in a simple table visual when I noticed that hundreds of rows were missing.  When I opened query editor I was able to see the data, so I double checked that no rows were filtered and verified the table was included in load and refresh.  I tried manually refreshing the data in power query, as well as refreshing data from the model, but the data was still missing from the model.  Finally, I reopened query editor and changed one of my columns to a different data type to see if that would "trigger" the data to load, and it worked.

While I'm happy to have the data I need, this doesn't seem like a sustainable solution if the issue comes up again.  I'm curious if anyone else has run into this issue and what you did to correct it.

For reference, I'm currently using desktop version 2.107.841.0 64-bit (July 2022) and my dataset is well below the 1GB limit.

[v-jianboli-msft]

Hi @jdwalker5 ,

What is the connection mode of your data? Please check the data view of your data:

Can you get all the data in the data view? If you can get all the data in the data view, the issue may caused by the table visual.

For example, table visual will remove duplicates from table visual:

If you want to keep duplicates, you need to add another column to make the row unique:

Output:

If this is not what you want, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

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

[lbendlin]

 but the data was still missing from the model. 

How did you confirm that?  Did you look at the data tab to investigate?

[jdwalker5]

I originally created a new page with no filters and brought the data into a table visual, but I also looked at the data tab to double check myself the data was missing from there too.  This is not something I've seen before and I thought it may be a bug in the desktop version.