1. In Power BI Desktop, choose File > Publish > Publish to Power BI or select Publish on the Home ribbon.

2. Sign in to Power BI if you aren't already signed in.

3. Select the destination. You can search your list of available workspaces to find the workspace into which you want to publish. The search box lets you filter your workspaces. Select the workspace, and then click the Select button to publish.
   
   

   Open

   

    

   Open

   

When publishing is complete, you receive a link to your report. Select the link to open the report in your Power BI site.

Open

The semantic model, and any reports you created in Power BI Desktop, upload to your Power BI site when you publish a Power BI Desktop file. When you republish your Power BI Desktop file, the semantic model in your Power BI site is replaced with the updated semantic model from the Power BI Desktop file.

Open

This process is straightforward, but you should know the following:

• Directly publishing a protected .pbix file from Power BI Desktop to the Power BI service is not supported for guest users, even if they have higher-level permissions. To update or publish reports from a protected .pbix file, guest users need to start from the Power BI service, using Get Data, for example.

• Two or more semantic models in Power BI with the same name as the Power BI Desktop file could cause publishing to fail. Make sure you have only one semantic model in Power BI with the same name. You can also rename the file and publish, creating a new semantic model with same name as the file.

• If you rename or delete a column or measure, any visualizations you already have in Power BI with that field could be broken.

• Power BI ignores some format changes of existing columns. For example, if you change a column’s format from 0.25 to 25%.

• Say you have a refresh schedule that is configured for your existing semantic model in Power BI. When you add new data sources to your file and then republish, you’ll have to sign into them before the next scheduled refresh.

• When you republish a semantic model published from Power BI Desktop and have a refresh schedule defined, a semantic model refresh is started as soon as you republish.

• When you make a change to a semantic model and then republish it, a message shows you how many workspaces, reports, and dashboards are potentially impacted by the change. The message then asks you to confirm that you want to replace the currently published semantic model with the one you modified. The message also provides a link to the full semantic model impact analysis in the Power BI service. From there, you can see more information and take action to mitigate the risks of your change.

• If the semantic model (and, if one exists, the report) in the Power BI service that you're overwriting has sensitivity labels that differ from the label in your .pbix file, a dialog appears. The dialog will prompt you to choose whether to keep the existing labels or overwrite them with the ones coming from your .pbix file.

1. After publishing the Power BI report to the Power BI Service (http://app.powerbi.com ) navigate to the semantic model settings by clicking ellipses(…) next to the semantic model from the workspace.

Open

Open

2. Expand gateway Connection setting and select the Gateway cluster(Example: ModelOp) and dropdown and select the gateway connection (Example: ModelOp with ServAcc) and apply the gateway connection.

Open

The Refresh section is where you define the frequency and time slots to refresh the semantic model. Some data sources don't require a gateway to be configurable for refresh, while other data sources require a gateway.

1. Set the Configure a refresh schedule slider to On to configure the settings.

Open

2. Select the time zone for the refreshes to be scheduled.

3. Set the Refresh frequency to Daily or Weekly.

4. For the refresh to be scheduled for different intervals, click on 'Add another time' and configure the timings accordingly.

5. Click ‘Apply’ to save the configuration.

The gateway runs on the computer that you install it on, be sure to install it on a computer that's always turned on. For better performance and reliability, we recommend that the computer is on a wired network rather than a wireless one.

1. Download the standard gateway.

2. In the gateway installer, keep the default installation path, accept the terms of use, and then select Install.

   Open

   

3. Enter the email address for your Microsoft/Office 365 organization account, and then select Sign in.

   Open

   

    

   The gateway is associated with your Microsoft/Office 365 organization account. You manage gateways from within the associated service.

   You're now signed in to your account.

4. Select Register a new gateway on this computer > Next.

   Open

   

5. Enter a name for the gateway. The name must be unique across the tenant. Also enter a recovery key. You need this key if you ever want to recover or move your gateway. Select Configure.

   Open

   

6. Review the information in the final window for confirmation that the gateway is online and ready to be used.

   Open

   

7. Now place the custom connector .mez file in the default path 'C:\WINDOWS\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors'

8. Navigate to connectors tab and make sure the custom connector 'ModelOp' is available. Select Close.

   Open

   

    

1. Open web browser and login to http://app.powerbi.com for Power BI Service

2. Click on settings icon on the top right and click on Manage connections and gateways as shown below

   Open

   

3. Navigate to ‘On-premises data gateways’ and confirm the gateway connection 'ModelOp' is available and the status is online.

   Open

   

4. Click on connections tab and 'New' connection.

   Open

   

5. Leave the default ‘On-premises' selection as is. Key in the next details as provided.

   Open

   

    

   a. Gateway Cluster Name - select ‘ModelOp’
   b. Connection Name - Enter the gateway connection desired (Example: ‘ModelOp Connection’)
   c. Connection Type - Drop down and search for ‘ModelOp Data' or key in ‘ModelOp Data’ and select the connection.
   d. ModelOp Center URL - Enter the source url (Example: https://lab3.modelop.center/)
   e. Authentication method: Select the appropriate option and enter credentials.
   For example: ‘OAuth2 Service Account’
   ClientID: 55tp75td4io3uh3rg8lde2b3hf
   Client-secret: 13n4vmjo3kaifrp7u0r8u6tve6c6q3u7k8hir94tq57f013jdimt
   f. Privacy Level: Leave it as ‘Organizational’.
   g. Click 'Create’
   h. Connection will be created with confirmation as below

   Open

   

Open

6. 'ModelOp Connection' is now available and ready to apply for the reports.

1. Upon selecting ModelOp Data, you will be prompted for the URL used to access your instance of ModelOp Center. This example assumes the ModelOp Center instance is accessible at ‘https://lab3.modelop.center/'.
   Then select preferred format for modelMetadata.custom(default: blank) or choose ‘Current’ for the default format or '3.3.1 Version - (Deprecated)’ for compatibility with older versions.
   
   

Open

2. Clicking OK will open another prompt to select an authentication method. to access an OAuth2-protected instance,
   a. Select Organizational Account | Sign In, then proceed to login using your ModelOp Center credentials.
   b. Select OAuth2 Service Account, then process to login using Client-id and Client-secret credentials.