[Data view] Problem with empty table in data view

[fobatai]

Hey guys, 

I am following a tutorial to learn Power  BI but i am kinda stuck.  The last time i saved the file it was allright so i probably did something wrong but i don't know where to search.

I have a table with some categories in it. 

But when i check it in the "DATA" view it's empty and no rows appear: 

It's probably very easy but i have no clue how to fix this.

Anyone got a suggestion where to look?

Thanks in advance.

[V-lianl-msft]

Hi @fobatai ,

If the problem persists,you can try to create a new "Blank" Query,  then go to the old query, click on "Advanced Editor", copy everything, then go back to the Blank Query, click on Advanced Editor, and paste. finally, delete the old query and click apply.

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

[az38]

Hi @fobatai 

check your data source via Power query mode

first, try Refresh preview.

Second, show right pane Query Settings for this data source, be sure there is no Filtering step

do not hesitate to give a kudo to useful posts and mark solutions as solution

[fobatai]

@az38 

I just checked the refresh preview and it shows the correct rows. 

also there are no filters applied in the power query editor:

[az38]

@fobatai 

try to refresh report in report mode and try to create simple visual Table and add these columns as visual columns

do not hesitate to give a kudo to useful posts and mark solutions as solution

[fobatai]

In the report view it's also empty

If you want i created a zip with the data Adventure work 

[az38 · Accepted solution]

@fobatai 

at first look, it seemed strange but it works for me but only after I change source folder for my actual, then apply and refresh

so, my guess is you need in Power query editor mode right-click to data source name and set active "Include in report refresh". after - apply and refresh

do not hesitate to give a kudo to useful posts and mark solutions as solution

[fobatai]

Yes! that was it!

Thanks!