Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
1. Import
  1. Export data into Power BI Desktop, create the reports or dashboards you need and save your file.

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

3.

  1. Select

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

. Click
  1. , and then select Select.

Info

Power BI will start

to publish

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

4.

Info

After successful publishing, you may review your report by clicking on the link or by going directly to your Power BI Service.

5. In your Power BI Service:

  1. Select Workspaces, and then select the workspace where you published your report or dashboard

under the Datasets find the name
  1. .

Workspaces.gifImage Added

  1. In front of your published report or dashboard

and click on vertical ellipsisin the opened menu
  1. , select Schedule refresh.

Image Removed

6. In the Schedule refresh window select the data set for configuring scheduled refresh

7. Expand the Gateway connection

Use OnSchedule refresh.gifImage Added

  1. [Optional] If it’s required, expand the Gateway and cloud connections section and set up a gateway connection according to your specific needs.

Info

If you don’t have a gateway installed, please follow the guide Download and install a standard gateway. You may use on-premises data gateway or

On InfoAlso

on-premises data gateway (personal mode). Please find more details here.

On-premises data gateway

On-premises data gateway allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources.

If you don’t have a gateway installed please follow the guide Download and install a standard gateway.

To use a data gateway, make sure the computer is online and the data source is added in Manage Gateways.

To add a Data Source to On-premises data gateway, please select the corresponding data sources and then click Add to gateway.

To add a Data Source to the gateway (standard mode):

  • Enter Data Source Name

  • Select Data Source Type: OData

  • Paste Data Source URL

  • Select authentication Method: Basic

  • Enter credentials (Username and Password) that were used for exporting Jira’s data

If you need assistance in configuring the gateway, please contact your Network administrator.

You may also refer to this article for additional information - Add or remove a gateway data source.

Gateway and cloud connections.gifImage Added

  1. [Optional] Select Edit credentials.

Info

If you experience one of the errors: Failed to test the connection to your data source. Please retry your credentials or Data source can’t be refreshed because the credentials are invalid. Please update your credentials and try again, follow the steps below. If you don’t face an error, please proceed to step 13.

Edit credentials 2.gifImage AddedEdit credentials 1.gifImage Added

  1. In the Authentication method field, select Basic.

  2. In the User name, enter your Jira username.

  3. In the Password field, enter your Jira password.

  4. Select Sign in.

Info

Also, you can use PAT (Personal Access Token) to schedule a refresh.

  • Select the Basic authentication method.

  • In the Username, enter token (a reserved word for Power BI Service)

  • In the Password, enter your PAT generated in Jira.

On-premises data gateway (personal mode)

On-premises data gateway (personal mode) allows one user to connect to sources, and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you’re the only person who creates reports, and you don't need to share any data sources with others.

If you have no personal gateways installed, you’ll be offered to Install it.

Refer to the Install the on-premises data gateway (personal mode) guide for more details.

Image RemovedImage Removed

Image Removed

8. If the message appears that the data source can’t be refreshed because the credentials are invalid simply click Edit credentials and provide the data source with credentials (via Basic authentication).

Image Removed

9. Expand Scheduled Refresh

  • set it ‘On

  • fill out all the fields to configure the refresh

  • click Apply to apply the changesJira-Configure.gifImage AddedJira Configure (1).gifImage Added

    1. Expand the Refresh section, and then turn it on.

    Refresh section.gifImage Added

    1. Select refresh frequency and time zone, and then select Add another time.

    Refresh frequency, Time zone, Time.gifImage Added

    1. Configure the time you need, and then select Apply.

    Apply.gifImage Added

    Tip

    Now your data set will be

    refreshing

    refreshed according to the configured schedule.

    Image Removed

    10. To review refresh history click Refresh history

    Image RemovedNext refresh.gifImage Added