Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 24

...

Info

Once you set your PowerBI application ID and credentials, you'll be able to start displaying PowerBI dashboards in the following areas of Projector Web.

Image RemovedImage Added


Permissions and Settings

...

  1. PowerBI Pro - at least one user needs to be on a Pro account.

    Warning
    titleTwo Factor Authentication

    Two-factor authentication must be OFF for this user


  2. Microsoft Azure - you have an Azure subscription
    Image Removed
    Image Added

  3. App Owns Data PowerBI instance tied to Azure - if you don't already have a PowerBI instance tied to Azure you can create one using this link https://app.powerbi.com/embedsetup/appownsdata 

    Tip

    If you already have an application you can get the application ID from https://portal.azure.com/#blade/Microsoft_AAD_RegisteredApps/ApplicationsListBlade. You can get the workspace ID by logging into https://app.powerbi.com and opening the workspace tied to your Azure application. Look in the URL for the workspace ID. If you aren't sure if your PowerBI is tied to an App Registration, it's easiest to follow the link above and create a new one. You can publish your existing reports to the new space.


    1. When creating your application request API permissions for the following


      Image RemovedImage Added

    2. After creating your application note the Application ID and Workspace ID

  4. API Access Enabled - under your App Registrations in Azure, open your application and go to API Permissions. If you requested permissions as suggested above you'll need an administrator to grant them. If you already have an app, grant the permissions by click Add a permission | Delegated permission | Select the Read permissions | click Grant admin consent for
    Image Removed
    Image Added Image RemovedImage Added
    Image RemovedImage Added
  5. User set to Admin - If the user accessing content via the API isn't already a workspace Admin, make them one at https://app.powerbi.com | Workspaces | Access.
    Image RemovedImage Added

Create PowerBI Content

...

You can author PowerBI content on either their website at https://app.powerbi.com or via their desktop software.

Image RemovedImage Added


Point Projector at PowerBI Instance

...

  1. Enter your application ID - if you do not know your ID see https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-your-organization#application-id
  2. Click Set Credentials and enter your username and password - requires the use of a Master Account with a PowerBI Pro license. Enter the master account's case-sensitive username and password here. Two-factor authentication is not supported
  3. Restart Management Portal

Image RemovedImage Added


Pull Projector Data into PowerBI

...

Use Get Data | Web to connect to your Projector data. 

Image RemovedImage Added


Once you have a report's URL, paste it into the form and Connect

Image RemovedImage Added

Ignore Quoted Line Breaks

PowerBI analyzes the first two hundred rows of your file to determine which settings should be used for import. In the event that you import fields with line breaks, like description fields, then PowerBI may accidentally split on those breaks and your imported data won't make sense. This occurs when the first two hundred rows are don't have line breaks. Excel then applies the wrong line-break settings.

To fix this, edit your query and for Source click the Gear icon. Change Line breaks to Ignore Quoted Line Breaks.


Image RemovedImage RemovedImage AddedImage Added





Create Content

The simplest way to get started is to build a table.  In the screenshot below we have connected to a Ginsu report.

Image RemovedImage Added


Publish PowerBI Dashboard

...

Tip

We need to figure out how to create workspaces and identify that it has been associated with an app registration.


Image RemovedImage Added



View on Web

Find your new dashboard in the workspace at https://app.powerbi.com. Copy the URL into notepad or another text editor. It should look something like this:

...

We'll be using them in the next section. 

Image RemovedImage Added


If you have shared your report correctly it will show up like the screenshot below.


Image RemovedImage Added




Show if
spacePermissionedit

Error Codes

While troubleshooting connection issues to PowerBI your Projector support representative may encounter the following 

Two factor authentication => Not sure what error message we get.

AdalException: unknown_user_type: Unknown User Type => Not using a master account

Microsoft.IdentityModel.Clients.ActiveDirectory.AdalServiceException: AADSTS50126: Error validating credentials due to invalid username or password.


...