Power BI Service - Data Missing after refresh

[jason81]

Hi,

My report works fine since publish to Power BI Service from Mar/18 but last week (mid of Aug).

The report works fine after refresh on my Local PC and Notebook. 

The data source came from "Teradata Database" and "Data entered as a static table"  so the query was merge via above 2 sources.

I was referring to a related topic but it seems not to apply to my case.

https://community.powerbi.com/t5/Report-Server/After-a-scheduled-refresh-the-report-has-no-data/td-p...

Any idea?

FYI,

I have visual filter "PURCHASE_REQUISITION_NUMBER" a string type.

[v-qiuyu-msft]

Hi @jason81,

Please update gateway to the latest version,  refresh the dataset again on Power BI service. Then open the report on Power BI service, click on Refresh button on report page to see if data display after refresh is finished successfully. 

If issue persists, please download the report from Power BI service and open it in Power BI desktop to check if dataset refresh do have retrieved data and report visuals do display data in Power BI desktop. 

Best Regards,
Qiuyun Yu 

[jason81]

Hi Qiuyun,

Thank you for your reply.

The on-premise gateway that I have is v14.16.6768.3 (2018/8/8).

The issue always occurs after refresh.

I download the download the report from Power BI service and open it in Power BI desktop.

I refresh the dataset to retrieved data and report visuals do display correctly on Power BI desktop.

Any other suggestions? Any suggestion is welcome! I appreciate your support!

[jason81]

Update!

I upgrade my on-premise gateway to the latest v14.16.6792.1 (8/23/2018).

I refresh the dataset to retrieved data and report visuals do display correctly on Power BI Service.
However, I still don't know the root cause of why it happened.