Incremental refresh data

Its hard to know the exact problem you are facing.  What makes you believe that its not working for you?  I've tried to follow through your steps and from what you have written it looks like you have done the correct actions, although you don't mentioned publishing this into the Power BI Service.

Just to clear out some obvious things:

Do you have Premium Capacity (Workspaces should have the Diamond next to them)?

Did you load it into the Service and allow it to do a full refresh?

Did you then attempt a second refresh, which should have only attempted the incremental portion?

Dear Sir,

Thanks For reply.But i donot know where these options.

i attached below image. i published. then i go to table and set incremental refresh..

but it is not working..

sir if yoy implemented kindly send me step by step snap shot.because its very urgent.kindly help me

Incremental refresh is part of the Power BI Web.  Power BI Desktop is a development tool, which is why you configure it using that program.  The actual incremental refresh only occurs as part of the refresh once you publish it onto the Power BI Service and is only available with the Power BI Premium license.

So kindly tell me where i am misssing.Please Guide me

i installed power bi desktop of may version.

Kindly tell me step by step 

1. Firstly you need to make sure you have purchased the Power BI Premium license.
2. You need to assign Premium to the Workspace you will be hosting your Power BI report in.
3. You need to select the "Publish" button on your Power BI Desktop, found in the Home Ribbon.
4. Select your workspace with premium from the "Publish to Power BI" window.
5. Find your report in the Power BI Service, head into "Schedule Refresh".  Configure any gateways that might be required
6. Use the "Refresh Now" option to have the Power BI Service grab the initial complete dataset
7. Once the refresh completes, select "Refresh Now" again.  This should complete much faster, and is a good indication that your incremental refresh is working.

Incremental Refresh does not work inside Power BI Desktop.  Power BI Desktop is required to configure the incremental refresh method.

i have no power bi premium license. if it is required then why this option is coming in right click on table.

incremental refresh window open..

So license is must..can we do without license

But this link is not Saying that we must have license..

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#publish-to-the-service

The Power BI Desktop doesn't have a method of checking whether your intended workspace uses Power BI premium.  That check is performed as part of the Publishing method.  It was also mentioned in the documentation you would have read up to this point. You are also instructed about this on the Incremental Refresh screen when you configured the refresh options.

Yes it does. Not only was it in the URL of your supplied link, its in the window of the graphic that pops up first on that page.  It is also in the very first sentance of the article as well as the Title of the article:

what is power bi premium

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

This should explain it.  Pricing starts around the $5,000 USD per month mark.

kindly tell me another way for incremetal data refresh.it is totally depend on license.

There isn't one.  Incremental refresh is very new and still considered a preview feature.  So far they have only released the version for Premium.  No other option exists within Power BI itself.

Hey panipat1990,

so it seems, that the most essential part is missing to utilize the benefits of incremetal refresh - the Power BI Premium dedicated capacity. This is what I mentioned in my first reply.

But MSFT already mentioned that they are considering to make this feature available for Power BI Pro users.

Be aware of the two things:

• there is no date available when Incremental Refresh will be available for Power BI Pro
• Incremental Refresh will never work in Power BI Desktop

Regards

Tom

one doubt is that power bi premium is setup or not..

If it is set up then what is power bi desktop so difference bewteen power bi desktop and power bi premium

Hey,

as Anonymous already mentioned, Power BI Desktop is a self-service BI tool that can be used for the following two aspects

• personal data anaylsis
• development tool to author (publish) reports to Power BI service

Certain tasks of the above mentioned aspects may overlap

I urgently recommend to get accquainted with Power BI Service:

https://docs.microsoft.com/en-us/power-bi/service-get-started

Read this carefully until the end also follow recommended next readings.

For now Incremental Refresh is a feature that is supported just by Power BI Premiumn (one licensing sku) from the Power BI Service offering. The configuration of Incremental Refresh is one of the tasks of the two aspects of Power BI Desktop

Regards

Tom

and one another doubt what is power bi report server and

diffrenece between power bi report server and power bi desktop..

if i made a application  in power bi desktop then i cannot open it power bi report server.... 

power bi desktop we need gateway and then what is report server

Diffrenece if same working both are done..

why report and why desktop..

we can same working on both ..

i am not understanding..kindly tell me

Hey panipat1990,

I guess this will get you started with your question "What is Power BI Report Server?":

https://docs.microsoft.com/en-us/power-bi/report-server/get-started

Read this carefully and until the end and also read

https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Please be aware that for now a separate Power BI Desktop version is needed

• to save Power BI reports
• created with Power BI Desktop
• to Power BI Report Server

Please accept one of Anonymous or mine answers regarding the incremental refresh issues as an answer and start a new thread regarding the different products.

I also urgently recommend to read the free ebook "Power BI from Rookie to Rock Star" that is available here:

http://radacad.com/blog

Regards

Tom