Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.