Versions Compared

Old Version 1

changes.mady.by.user Liubov Topchyi

Saved on

compared with

New Version 2

changes.mady.by.user Liliia Ostrovska

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Users can publish Power BI reports and dashboards in  Power BI Server or Power BI Service. However, the Power BI reports and dashboards won’t refresh unless users apply a refresh, either based on a refresh schedule or on-demand. Scheduled Refreshes are the scheduling tasks set for data extract refresh so that they get refreshed automatically while publishing a report and dashboard with data extract. This also removes the burden of republishing the reports and dashboards every time the concerned data gets updated.Import

  1. Export data into Power BI Desktop, create the reports or dashboards you need, and then save your file.

Click

  1. Select Publish,and then Sign in with your Power BI Service account (if you are not signed in).

  1. Select a workspace where you’d like to publish your report or dashboard

. Click

  1. , and then click Select.

Info

Power BI will

start to

publish your report or dashboard to your Power BI Service workspace.

Info

After successful publishing, you may review your report by

clicking on

selecting the link or by going directly to your Power BI Service.

  1. In your Power BI Service

:

  1. , select the workspace where you published your report or dashboard.

under

  1. Under the Datasets section,find the name of your published report or dashboard

and click on

  1. .

  2. Select the vertical ellipsis

in the opened menu

  1. , and then select Schedule refresh.

In the Schedule refresh window:

  1. If you see the

message that your

  1. warning “Your data source can’t be refreshed

simply click Edit credentials and provide your data source with credentials selecting the Basic authorization.

Credentials can be found under the Power BI Connector app --> Menu--> Settings in your Shop.

Image RemovedImage RemovedImage Removed

Expand Scheduled Refresh

  • set it ‘On’

  • fill out all the fields to configure the refresh

    • click Apply to apply the changes

    1. because the credentials are invalid. Please update your credentials and try again.“, select Edit credentials.

    Image Added

    1. In the Authentication method, select Basic.

    2. In the User name field, enter the copied Login credential.

    3. In the Password field, enter the copied Password credential.

    4. Select Sign in.

    Info

    How to find the credentials is explained in this guide, step 5.

    Image Added

    1. Expand Scheduled Refresh, and then set it On.

    2. Configure the refresh as needed, and then select Apply.

    Tip

    Now your data set will be

    refreshing

    refreshed according to the configured schedule.

    Info

    To review refresh history

    click

    , select Refresh history.

    Please note: actual

    Actual data appears according to the manual preparation or to the preparation schedule you configured in your shop. Data preparation can take up to several hours, depending on its size. So, for example, if you want to

    import

    export fresh data in the morning, you need to plan an update for the night.