Skip to main content

Power BI

New

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

5e5eceb0 0add-4336-ac46-19582dc56257 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.