cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danwscott
Frequent Visitor

Reports are refreshing with new data, but the dashboard hasn't for about a week now.

Our reports are refreshing with new data daily, but the dashboard hasn't for about a week now (since the 13th, actually).

5 REPLIES 5
ashishrj
Power Participant
Power Participant

@danwscott Try uploading the source file (pbix/excel) again. Even I faced a similar problem. Re-uploading the same help me resolved the issue. Might be this is because of the updates going on in Power BI services.

alaeddin14
Helper I
Helper I

Hi @danwscott

 

  1. Did your dashboard refresh normally before the 13th Jul?
  2. How do u know that the report has refreshed with the new data?
  3. What is your data source?
  4. If the data source is on-prem, are you sure the Gateway is configured properly and successfully runningat the time of the refresh?  

 

Alaeddin

@alaeddin14:

 

1. Both our dashboard and the reports updated daily before the 13th.

2. I can compare results in the report with running MDX (or simply browsing) against the tabular model.

3. Our data source is a tabular model on our premises.

4. I can't say for sure about the gateway, but clearly the reports are able to read new data daily, and I would expect the dashboard would be able to properly display that updated report.

 

 

@ashishrj:

Thanks, but our data source is not excel, but rather a tabular model on premises, and there is no pbix file as the reports and dashboard were designed entirely on the Power BI site.

Hey danwscott,

I tested this out this morning and the refresh took about 30 minutes to the dashboard, but it was a really small update. If you haven't see this, the following is straight from the troubleshooting site (link below)

 

Connector installed successfully and reports work, but tiles don't get updated:

  1. Power BI automatically updates report tiles connected to an Analysis Services server. The update frequency is every 10 minutes.
  2. Check you're able to open the report and see latest data.
  3. Check if you're able to pin the visual from Report and check if the latest data is showing in the tile on the dashboard.
  4. Start SQL Profiler and check if there are queries being sent to the Analysis Services tabular database.

If you've followed all these steps and are still having problems, click  in the main Power BI page, then click Contact Support. Send us:

  • Any logs that are generated during installation, if there were errors.
  • Any error messages you’re seeing (including the Technical Details) during configuration.
  • Any errors that appear under Data Management Gateway in Event Viewer.
  • Any ‘Audit Failure’ events in the Windows Security log related to the account you’re using to connect to Analysis Services.
  • Any errors you see in SQL Profiler while trying to connect from Power BI

Link to Trouble Shooting Site

 

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

My dashboard just updated.  As I have done nothing to cause it to do so, I presume some change was made on Microsoft's end.

 

Thank you very much.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors