Published report can't show any values in any tabs

Anonymous — Thu, 04 Aug 2022 11:04:02 GMT

Hi, the issue is once the report is published, after scheduled refresh, all values in the report has become 0 or empty.

The scheduled refresh was completed without errors.

The report can be refreshed in the deshtop version with no issues.

There's no boolean type filters in the values.

Can anyone help please?

Re: Published report can't show any values in any tabs

v-henryk-mstf — Mon, 08 Aug 2022 03:24:58 GMT

Hi Anonymous ,

What is the corresponding connection pattern of your data source? If it is similar to direct query mode, then after publishing the report to service, you want to configure the connection credentials of the data source through the gateway. Otherwise, the query cannot access the data in the data source.
You can refer to the following document for details.

Add or remove a gateway data source - Power BI | Microsoft Docs

Another thing you need to confirm with you is whether the processing is correct for boolean values, refer to the following similar solution.

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best Regards,
Henry

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

topic Published report can't show any values in any tabs in Report Server

Published report can't show any values in any tabs

Re: Published report can't show any values in any tabs