Solved: Report shows no data

ELIU · ‎08-02-2024

I have report scheduled to refresh 3 times daily. Everytime the semantic model refreshes susscefully based on the refresh history. However, after the second refresh, there is no data displaying in the report. The other two refreshes are fine. Data is pulling from our on-prem database.

Any hints why? Thanks!

Sahir_Maharaj · ‎08-02-2024

Hello @ELIU,

I would recommend checking the availability and performance of your on-premises database during the problematic refresh, as network issues or long-running queries might cause incomplete data retrieval.

I believe it would also be worthwhile reviewing the service logs to provide insights into any errors or warnings specific to that refresh.

Maybe try testing a manual refresh during the scheduled time to determine if the issue is time-specific or related to the scheduling process.

Hope this helps.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)

➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ About: https://sahirmaharaj.com/about.html
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now

LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning