Resolver IHowdy you unfortunate reader,
If you are are reading this you probably spent some time trying to solve your issue.
Hope I can Help.
SPOILER: CHECK IF YOUR FILTERS ARE SET TO BOOLEAN VALUES.
Situation.
Created a nice report on a sharepoint list. Showed it to my client on the desktop and even the published version. General reaction ..==> "giveme giveme". Okay, give me 5 minutes and you are good to go...but then.. set up scheduled refresh.
Before refresh:
After refresh:
Tried a zillion things (removing backgrounds, all kinds of powerquery stuff, changing filters, sources, downloading PBIX refresh locally, etc..)
Finally edited the report in de powerbi services.
Selected all (empty) visuals and copied them to a new TAB. By the way duplicate page does not work.
Et voila.
Okay so the data is still there. Copied all original report like this. Ending up with some extra tabs.
Let's refresh again: After changing some date in the source so I'm sure the data is really refreshed.
Still the original reports show up empty. The new (v2) version all showed refreshed data.
Okay let's download the report and see what powerbi desktop will do/show/discover/debug..??
Compered report "planning" and "planning v2" (the version created online).
Quickly discovered difference in Page level filter:
Report "Planning"
Report "Planning v2"
In retrospective: DO NOT USE BOOLEANS IN FILTERS.
Change it to text in powerquery, change you're filter setting, and you are good to go!!.
Have a very nice day and keep on smiling 😊.
KR Wouter Kessener