Power BI service not showing all data

[Guyz]

Hi guys,

for a few days now, im having very weird issue.

my main dataset not showing all the sales data, theres like missing rows in the data that didnt loaded.

However, when i download the PBIX, and refresh from the desktop application. it works fine, showing all the data correclty.

I assumes theres might be a resource problem.

so i upgraded to E3 user - still didnt solve the issue.
I tried to delete old datasets from my workspace - didnt work

I tried to shrink the data set - still didnt work.

any advise would be appretiated.

[Greg_Deckler]

@Guyz First thing to try, reset the report to the default in the service. 

[Guyz]

that was one of the first things that i checked - its not the issue.

for example, i have a table that shows sales by category.

few of the categorys are missing, and they go under blank category.

its like the service loads 50% of the data or so.

and on the dashboard it works 100%.

i also try to change and update my gateway, updated my service as well.

my dataset source connects directly into SAP\BW database.