Refresh data in Power BI reports

 When you publish a report, Power BI will not automatically update the data in the report from Sage 200cloud.

To make sure that your reports shows up-to-date information, you'll need to:

  • Set up an on-premises data gateway in Power BI.
  • Set up a refresh schedule so that Power BI can refresh the data in your reports and dashboards for you, or refresh the data manually.

Set up an on-premises data gateway in Power BI

The on-premises data gateway connects your data in Sage 200cloud and the Power BI Service.

You will need to install the on-premises data gateway and configure it for the Sage 200cloud custom connector.

Requirements

You can find requirements and further information about the on-premises data gateway in the Microsoft documentation: On-premises data gateway

  • We recommend that you install the gateway on a computer that is always on (such as your server), since the gateway will not be able to refresh your data if it is turned off or asleep.

Install the gateway

You can find more information about installing the on-premises data gateway in the Microsoft documentation: 

  1. Download the on-premises data gateway from Microsoft.

    Download the Microsoft on-premises data gateway

  2. Install the application.

    • Choose the recommended option to install On-premises data gateway (not the personal mode option).
  3. Sign in using your Microsoft account. Use the same account as you use for the Power BI Service.

  4. Enter details for the on-premises data gateway.

    • Enter a data gateway name, such as "Sage200DataGateway", and a recovery key.

  5. Once the data gateway is set up, you'll need to set up access to the Sage 200 custom connector.

    1. Move to the Connectors tab.

    2. The gateway uses a service account PBIEgwService to connect to the Sage 200 custom connector.

      The gateway will show a folder where it expects to find custom connectors, for example C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors.

      You must change this default folder to the location of the Sage 200 custom connector. Select ... and browse to the folder that contains the connector. By default, this is installed to Users\(your username)\Documents\Power BI Desktop\Custom Connectors\.

      Once the gateway finds the Sage 200 custom connector (Sage200.mez) in that folder, it will display Sage200 as a custom data connector.

    3. Give the service account PBIEgwService permission to access the folder that contains the Sage 200 custom connector.

      • Browse to the folder in Windows Explorer, then open its Properties and move to the Security tab.
      • Add the group Everyone and give it permission to Read the folder.

Set up the Sage 200cloud custom data connector

You can find more information about setting up custom connectors in the Microsoft documentation: Use custom data connectors with the On-premises data gateway

Once you have installed the on-premises data gateway, you must configure it in the Power BI Service.

  1. Sign in to the Power BI Service.

  2. Select Settings (in the toolbar), and choose Manage gateways.

  3. Select your gateway name, such as Sage200DataGateway.

    If you only have one gateway, then it will already be displayed.

  4. Select the option to Allow user's custom data connectors to refresh through this gateway cluster, then click Apply.

  5. Select Add data sources to use the gateway.

  6. Enter the Data Source Name, such as Sage200.

  7. Set the Data Source Type to Sage200. If Sage200 is not in the list, go back and check that the option Allow user's custom data connectors to refresh through this gateway cluster is selected for the gateway.

  8. Select Edit credentials.

    1. Set the privacy level to Organizational.
    2. Select Sign in, and sign in using the same Microsoft account that you used to set up the gateway.

  9. The Power BI Service will indicate if the connection is successful.

  10. Select Settings (in the toolbar), and choose Settings.

  11. Select the Datasets tab, then open the Gateway connection settings.

  12. Check the settings for your gateway:

    1. Set Use a data gateway to On.
    2. Select your gateway, then click Apply.

Refresh your report data

You can find information about refreshing data in the Microsoft documentation: Data refresh in Power BI

After installing and setting up the gateway, you can now refresh your report data from the Power BI Service. You can refresh the data automatically by setting up a schedule, or refresh the data manually.

  1. Sign in to the Power BI Service.
  2. Browse to the workspace where you publish your reports, and find the Dataset that you want to refresh.

  3. Select the menu. for the dataset and choose how you want to refresh.

    • To set up a schedule to refresh the dataset automatically, select Schedule Refresh.
    • To manually refresh the dataset, select Refresh Now.

Comments

Post a Comment

Popular posts from this blog

What is Power BI: Architecture and Features Explained

Image
We all know that Power BI is one of the best BI tools, and many organizations are using this tool to generate reports and dashboards to make effective business decisions. Before using the Power BI services and features, you should know about the Architecture of Power BI. Because, you should know how the Power BI services, components are being used to transform the data, create the reports and dashboards. To get in-Depth knowledge on Power BI you can enroll for a live demo on   Power BI online training Microsoft Power BI Architecture: Power BI is a business platform that includes several technologies to work together. It delivers outstanding business intelligence solutions. Power BI Architecture contains four steps.  Let us discuss these four steps giving insightful information about each one of them. Data Integration Data Transforming  Report & Publish Creating and Dashboard 1. Data Integration:  Data is extracted from different sources which can be differen
Read more

Fundamentals of Blockchain Network Security

Image
Blockchain is a revolutionary technology, yet its security is often over-exaggerated. While its design does help protect against a variety of different security threats, the technology is vulnerable to attack. In this post, we discuss three of the fundamental security assumptions of blockchain and how they are violated. (Mostly) Benign Participants Blockchain technology is designed to create a secure, decentralized, and distributed record of the history of the blockchain system. The way that this is accomplished is by relying on the network of blockchain participants to (mostly) act in their own best interests and in that of the system as a whole. To get in depth knowledge on  blockchain  , enrich your skills on  Blockchain online training  professionals Blockchain wants to make sure that users participate in block creation, so that the system remains decentralized. It does this by providing incentives for creating these blocks in the form of block rewards and transaction f
Read more

Scope of UI designers

Image
You need UI designers to make the web (and practically all sorts of technology) aesthetically pleasing and user-friendly for all. But what makes a UI designer 's role so significant? Let's look at it closer. Good UI is key to good UX When interacting with a digital product, UI designers create all the screens and touchpoints the user encounters. From color and typography to spacing, imagery, buttons, scroll bars and more, they take care of everything. To get in depth knowledge on UI, enrich your skills on online ui training Course UI designers are not only responsible for making things look nice, though; they think about how the human mind works, using good design to intuitively direct the consumer around the product. Together with the designers of User Experience (UX) they ensure a positive user experience. In fact, while UX and UI are two distinct career paths, without good UI there is no such thing as good UX! UI designers guarantee accessible and inc
Read more