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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Amgalanbaatar
New Member

Dataset refresh is not reflecting change in oracle view

I have a dataset that pulls data from Oracle view, that is published to service and refreshed daily incrementaly. Since then I dropped the view and created again with query that adds additional rows to the original view. Column definitions didn't change, all I added was union all followed by subquery to original view. Strange thing is dataset refreshes successfully, the rows I added is not showing, but new data is inserted from old view; It's as if PBI service saved the View source code when published and using that code to retrieve data instead of using redefined view. Is that even possible?

I refreshed dataset PBIX in desktop and refreshed there, and added rows are showing. I don't want to republish and refresh whole dataset again, did anyone encounter same issue? What could be happening here? 

1 REPLY 1
GilbertQ
Super User
Super User

Hi @Amgalanbaatar 

 

It sounds like there is some small change in the view which is different. That is why the PBI Service is using the old version and PBI desktop is showing the new version.

 

If you are using Power BI Premium Per User or Premium you can use the ALM Toolkit to publish the updates without having to re-process all the data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors