Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Antonio_Gomez
Resolver I
Resolver I

Partial Load Report Server

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

Antonio_Gomez_0-1659512807917.png

 

And, this is what I publish before the scheduled update

Antonio_Gomez_1-1659513418902.png

 

 

1 ACCEPTED SOLUTION
Antonio_Gomez
Resolver I
Resolver I

@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!

 

View solution in original post

3 REPLIES 3
Antonio_Gomez
Resolver I
Resolver I

@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!

 

v-henryk-mstf
Community Support
Community Support

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.

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Kudoed Authors