power bi importing data not showing up to date data

[wpf_]

Hi I am using the get data/importing from oracle database.  Only one table of over 13 million records, but it only shows up to june 23 2020, it does not show anything over that.   I see the current data in our database.  Any help is appreciated. Thanks.  

[parry2k]

@wpf_ do you have data refresh enabled for this table? Are you using import? How big is the model?

[wpf_]

Hi @parry2k 

Yes i am using import.  The pbix file is 41 mb, the table has 13.7 million records.   I imported a fresh one into a new pbix file and still no up to date data.  and I also tried refreshing after, both in report view as well as right clicking table in data view.  Is there a limitation to how much i can import?  

Is there a way to limit data to after a certain date say 2017?  Thanks 

[parry2k]

@wpf_ there is no limitation as far as model size is withi 1gb, are you connecting to correct data source and correct table? I'm sure you do but double check.

[wpf_]

@parry2k ,

Yes it is the right datasource and right table.  Does the DB admin need to refresh data from his side?  Wondering out loud. Thanks

[parry2k]

@wpf_ hmm, not sure what does that mean. I though you are checking the backend data outside power bi and finding there is discrepency. So question is, the source/table you are connected to, do you have other way to connect and check the data there?

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[wpf_]

@parry2k ,

We are connecting to db through toad and seeing data up until today.   Is there anything in gateway which we are connecting through, that needs refreshing?