topic Re: Partial Load Report Server in Report Server

Partial Load Report Server

Antonio_Gomez — Wed, 03 Aug 2022 08:00:23 GMT

Hello Everyone!

I need your help.

I'm using PBI Report Server to publish one dashboard and for some reason when the scheduled update occurs the data shown is empty in almost every sheet.

This happens only with this dashboard. I have published others and everythhing is OK

This is what happens

And, this is what I publish before the scheduled update

Re: Partial Load Report Server

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

Hi Antonio_Gomez ,

For the report server, dashboard is not a supported feature for it. Check this idea, it is still a feature to be updated.

I guess by dashboard you mean report, when configured with a scheduled refresh the data is not displayed in the report, right?
First refer to the following steps and common information about configuring Power BI report server for scheduled refresh.

Troubleshoot scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

Configuring Power BI Scheduled Refresh Simplified: 8 Simple Steps (hevodata.com)

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.

Re: Partial Load Report Server

Antonio_Gomez — Mon, 08 Aug 2022 10:59:03 GMT

Thanks v-henryk-mstf , I'll talk with the DB administrator, maybe the problem is there

Re: Partial Load Report Server

Antonio_Gomez — Wed, 21 Sep 2022 11:20:14 GMT

v-henryk-mstf

I decided to make from zero the dashboard. The person that made the one in which I was working was a disaster, there were useless tables, nonsense relationships and inefficient queries.

I noticed that the load time was too much and I don't have the permissions to watch the errors in the login. So, I assumed that was a problem in the load runtime.

That is why I decided to start from zero, doing all right and it worked!