cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
h4tt3n
Resolver I
Resolver I

Does incremental refresh work equally well with all data import methods?

Hello everyone,

 

I work at a small startup company where I develop a wide range of reports for our customers. I have been using several different ways of acquiring data for the reports; Json strings to API, SQL scripts, and direct connection to our Azure SQL database. 

Now I am wondering if the newly introduced incremental refresh function works equally well with all these different types of data import methods, or if there is one preferrable way to do it?

Especially, does incremental refresh work if all data is imported with SQL?

Cheers,

Michael

1 ACCEPTED SOLUTION

That is my understanding, yes.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Greg_Deckler
Super User IV
Super User IV

From:
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Limitations
Currently, for composite models, incremental refresh is supported for SQL Server, Azure SQL Database, SQL Data Warehouse, Oracle, and Teradata data sources only.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




@Greg_Deckler Thank you, that clarifies a few things.

 

But just to be completely sure I don't misunderstand you:

If I log into our azure sql database and get data via a "source" SQL query in the query editor, will incremental refresh work too?

 

 

That is my understanding, yes.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors