Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!

Have you wanted to use a Stored Procedure with Incremental Refresh? Patrick has a way that you can do just that!

Sandeep's blog:

Sample:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #IncrementalRefresh #GuyInACube

[ItsNotAboutTheCell]

Sandeep Pawar is a great community contributor! Love this video!

[soumikdas-hwvn]

This video is amazing, I was stuck where I had a monthly agggregated file in Synapse where daily dates were not present, only first and last day of the month was present, using normal import with incremental refresh was not working, but these method works like a charm. Thanks buddy.

[roborchiston]

oh that is some of the dopest coding presentation i've ever seen. don't know what tools that is but super nice use of Highlighting and zooming which I've only seen used at in person presentations, not online. So so much easier to follow when you can see what the presenter is drawing attention to. Only thing I could add is use a bigger red mouse pointer for visability and your video of yourself seems out of focus (maybe that was intentional to stop the bots...). thanks!!

[bz]

Great video, short, clever and useful, thanks Patrick! 👍🏻🙂

[adrianhenning]

Hi Patrick, this is awesome.

I have a unique requirement on top of this. We have multiple client databases, all the same structure and without a DW in place. We need to connect to these one-by-one using dynamic connection strings etc.

Since the example you explained speaks to "Import Mode", do you have any advise how we can use direct query or ... point me in the direction of doing all this without duplicating e few 100 reports to share with customers, since they will all have their own datasets.

Oh yes, on top of that, the are being embedded in an application 😝

Any help will be appreciated! 🤗

[amarkhaliq]

Can you show how you manage your datasets in the database for example your tables or views. Things such as names for tables, sql code, say you have your customers table how would you bring the table in for funded sales or pipeline sales would you filter the customers in power query or create two seperste customer tables/views

[guilhemdelorme]

Great explanation as always. I'm actually trying to test if incremental refresh car work on a view (defined as SELECT clause on the Facts table with some joins in there as well). So far no improvement in the dataset refresh time, so I guess not... Although I couldn't find any definitive answer on that point online.
You seem to drop in the video that it should be possible? Is that so?

[razelllamanzares]

Thank you for this tutorial, is that possible to do this on Sept 2022 PBI version

[johann-andreasspindler]

Hi Patrick, great video! Can you show how to pass a whole table from an other datasource to a storedProcedure as TableType? Is it even possible?

[mrithulas]

Can we connect stored procedure in power bi using direct query?

[JuanFerrer]

Hi Patrick, this is works too in oracle databases?

[sravanpesari]

I am currently facing one more issue with how to call Oracle stored proc with parameters in Direct Query mode? Appreciate your inputs or any workaround

Thanks

[PatrykLukanowicz]

Hi, as always great job there! I am little bit concerned about partitions and reload for last year data. I am aware how new set of records is being created in this approach and limited in this example to 1 year of data. But what logic is being used underneath to delete old records that are assigned to last 1 year in case they changed in mean time.

[gauravvarma]

Hi Patrick, ned your help on an odbc database created by a SCADA software called Clear scada. We are struggling with trying to implement incremental refresh with this database

[juanpablocastelli]

Do you know if this functionality are going to added for direct query models? I need it!!!!

[maribelmanibo]

does this help get around the limitation of being unable to download PBIX from web service because of an incremental refresh set up?

[wbwestful]

I'm new to Power BI. Does this work with Embedded reports and does it require a Pro license?

[georgiescicluna]

Hi Patrick great video. Unfortunately when l set the Incremental refresh i get a warning message saying "Unable to confirm M query can be folded" It all seems to be working. Refresh time doesnt seem to have reduced to much though.

[nzburger]

For some reason my incremental refresh says that I have to set up parameters, even though I set them up the same as in the example. Do I have to select DirectQuery mode when initially setting up the connection?

[megabuilds]

I didn't get this Store procedure thing, can anyone helpme understand it....