cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Data Missing after Service refresh

Hi, 

After publishing a report from Desktop to Power BI Service some data is missing from 2 tables, not all data but some.

If i download the .pbix again and open it in desktop, the data is missing from the table view, but if i go to edit queries i can see the data again. Performing a refresh again in ReportView makes the data appear in the reports.

 

If i publish the report to Service again, after the inital refresh, the data is missing again.

The 2 tables both have date fields which have been changed to type: date in query editor and have relationships with a calendar table. My Gateway is updated to the latest version.

The image below is the contents of one of the tables for this month in Desktop before uploading to service- 24rows

desktoprec.PNG 

Next, the same table after uploading to Service and letting it refresh, then downloading the pbix and opening again in desktop - 7 rows

servicerec.PNG

Finally, Clicking Query editor for the above table

serviceeditor.PNG

All the rows are there, just not being displayed. If i close query editor and click refresh in Report view, the rows come back..

Help Appreciated!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: Data Missing after Service refresh

Okay, so i found the problem, and after all i suppose it's my fault 🙄

 

In my sql query for these two affected tables, i had the following IN condition using two words using the Finnish character Ä

queryerror1.PNG

 

So dekstop handled this just fine but Service not. My bad.. Thanks for the assistance

Keith

View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

Re: Data Missing after Service refresh

Hi @kleighton,
that's a rather strange issue.
Can you show us the query steps in the Query Editor? Is there a filter applied over there maybe?


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Highlighted
Microsoft
Microsoft

Re: Data Missing after Service refresh

Hi @kleighton ,

Does this report apply any filter, RLS or bookmark in Power BI Service? And could you please try to rename the related report file and republish it to Power BI Serive?

Best Regards

Rena

Highlighted
Helper I
Helper I

Re: Data Missing after Service refresh

Hi, 

 

Sorry for the delay in my response. No RLS or Bookmarks, Lots of filters within the report but i havent put any on Service specifically.

I tried to save with a different name and publish, Same problem, Data is fine until you refresh from Service. 

 

as far as steps in editor goes,

editor.PNG

Im changing from Date/Time to Date only. 

 

I have quite a lot of other reports in service and have never seen this..

 

Highlighted
Helper I
Helper I

Re: Data Missing after Service refresh

and i just tested removing this step from editor, so leaving as datetime and still the same issue, when refreshing from service.

I dont understand whats going on here?

Highlighted
Microsoft
Microsoft

Re: Data Missing after Service refresh

Hi @kleighton ,

Thanks for your feedback. Please check the solution in this thread, maybe you have similar issue with this one. Hope it can resolve your issue.

Best Regards

Rena

Highlighted
Helper I
Helper I

Re: Data Missing after Service refresh

Okay, so i found the problem, and after all i suppose it's my fault 🙄

 

In my sql query for these two affected tables, i had the following IN condition using two words using the Finnish character Ä

queryerror1.PNG

 

So dekstop handled this just fine but Service not. My bad.. Thanks for the assistance

Keith

View solution in original post

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors