Skip to main content

Power BI

Needs Votes

Refresh PowerPivot Data Model that contain SQL statements

Vote (16) Share
Chris Brady's profile image

Chris Brady on 16 Apr 2015 23:52:09

I often write the sql statements that pull from our Oracle database to populate tables either directly in the power pivot data model, or through power query which then populates the data model. After connecting my data model to Power BI as a dataset refreshing the data doesn't work. Is there a way you can refresh this type of dataset or is that still under review?

Comments (1)
Chris Brady's profile image Profile Picture

Per Solli on 05 Jul 2020 22:14:34

RE: Refresh PowerPivot Data Model that contain SQL statements

For this use case you can use Power Update from www.power-planner.com. Free trial.