Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data not loading into Report Pages but loaded in Query

Hi Everyone,   we're using Power BI for every of our customers and we have experienced severe problems with data refresh.    Data Stored in a PostgreSQL Database Storage Mode in Data Model: Impo...
Need Help
jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous 
You are able to view data in the Query Editor as after applying some filters or transformation the underlying M Query changes. Any changes in the M Query refreshes the Query and data and whenever you choose Close and Apply data refresh happens. If there are no changes in the Query for example if you havent done anything like applying filters or transformations that particular table wont refresh and all the tables where any sort of change has been done will only refresh.Its not basically an issue but thats how Power BI Works ðŸ˜€

 

If you want to view  the latest data you can publish the report on Power Bi Service and enable schedule refresh. This will refresh the underlying data set and you would be able to see the refreshed data without any issues.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

Please accept this as a solution if you question has been answered !!

Appreciate a Kudos ðŸ˜€

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jaideepnema,

     

    thanks for your reply! We did not have that problem years before it only occured now. We have a scheduled refresh for every of our 120 customers' reports and they always refreshed with no problems. A few months ago the problem occured first, that the report in the online service did "refresh" but it didn't pull the new days from the query. There isn't an particular error shown for this report and the gateway also refreshes the report, when i click refresh manually in the cloud but it still doesn't pull the new days.