No video

Power BI Incremental refresh made simple.

  Рет қаралды 7,011

SQLBits

SQLBits

Жыл бұрын

Power BI has many amazing features that will make life much easier and more efficient. Yes, incremental refresh is one of them, so you read the official Microsoft documentation. Maybe once, then again, just a few more times. Now you have more questions than answers. Or was that just how I felt? If you thought the same thing or want to ask questions, this session is for you.
This session will look at setting up incremental refreshes for both Dataflows and Datasets. Explain what ALL the different settings mean and words we can all understand. How will I perform this daring feat? Using a combination of words, pictures and examples. As part of the presentation, I will share the demo code so you can try this at home.
Leaving this session, you will understand how to configure Incremental Refresh and use it when you return to your office. You will have a link to the code shown as part of the session. So that you to can see how it works.
Speaker: Robert French SQLbits.com/sp...
Speaker BIO: Roberts primary passion to help others to achieve more by sharing some of the knowledge he has been privileged to receive from others.
SQLbits.com/Ses...
Tags: Azure,Power BI,Power BI Embedded,Data Loading Patterns & Techniques,Data Visualisation & Modelling,DataOps & Automation,None of the above

Пікірлер: 2
@playmysongjo
@playmysongjo 10 күн бұрын
Hi Robert, Thank you for this well explained demo. I have one question - you mention that you set up a dataflow and on top of that a datasource. Finally you create the report. Why do you have both a dataflow and a datasource? Thank you!
@user-ct5uq3rs1s
@user-ct5uq3rs1s 6 ай бұрын
Hi I know this is a very late comment, but in doing the deletes, I noticed that the IsDeleted flag is included in the folded query for checking the Max LastUpdatedDate for each partition, so it excludes deleted rows during its check. Therefore, that partition with the deleted row is not refreshed. I have dug through almost all the videos, blogs and documentation on this and this is not addressed in the ones that recommend the soft delete approach.
Configuring Incremental Refresh in Power BI
16:01
BI Gorilla
Рет қаралды 85 М.
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 43 МЛН
Query folding in Power Query
20:46
SQLBits
Рет қаралды 2,2 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 60 М.
Advanced Incremental refresh in Power BI - Mark Endicott
40:51
Time Intelligence in Power BI
50:27
SQLBits
Рет қаралды 6 М.
Write-back with Power Apps in Power BI
46:51
SQLBits
Рет қаралды 8 М.
The Power BI Gateway   All You Need to Know
20:19
RADACAD
Рет қаралды 49 М.
My CHECKLIST for troubleshooting Power BI Performance
12:37
Guy in a Cube
Рет қаралды 36 М.
路飞太过分了,自己游泳。#海贼王#路飞
00:28
路飞与唐舞桐
Рет қаралды 43 МЛН