Skip to main content

How do I connect Data Share to Power BI?

Data Share gives your company a read-only copy of its Assignar data that you can load into Microsoft Power BI to build your own reports.

Data Share gives your company a read-only copy of its Assignar data that you can load into Microsoft Power BI to build your own reports. To connect Data Share to Power BI, you add an Amazon Redshift data source in Power BI Desktop with the connection details Assignar gives you, then choose the data feeds to load. Anyone with Data Share login details from Assignar can do this.

Data Share is set up by Assignar, not from a page on the Assignar dashboard. There is no Data Share menu on the dashboard.

Before you start

  • Your company needs Data Share set up by Assignar. If you don't have connection details, see What data and relationships are in Data Share? for how to ask for it.

  • You need the server address and a password from the Assignar Data Team. The database name is always assignar.

  • You need Power BI Desktop on a Windows computer.

  • Your login gives you access to particular data feeds (tables). Make sure you've been given access to every feed you want to use.

Connect Power BI Desktop to Data Share

To connect Data Share to Power BI Desktop:

  1. Open Power BI Desktop.

  2. Click Get Data > More.

  3. Choose Database > Amazon Redshift, then click Connect.

  4. Enter the connection details:

    • Server: the server address from the Assignar Data Team.

    • Database: assignar.

  5. Click OK. When Power BI asks for credentials, enter:

    • User name: the email address Assignar set up for your Data Share access.

    • Password: the password from the Assignar Data Team.

  6. Click Connect.

  7. In the list of Data Share feeds, tick the ones you want, such as timesheets, allocations or forms.

  8. Choose how to load the data:

    • Click Load to bring in all rows.

    • Click Transform Data to filter the rows or write a custom query that loads only part of the data.

The feeds appear in the Data pane, ready for reports. To join feeds together, see What data and relationships are in Data Share?.

Refresh Data Share data in Power BI

To get the latest Data Share data in Power BI Desktop, go to the Home tab and click Refresh. You can also set up a scheduled refresh. Assignar asks that you don't refresh Data Share more often than once every hour.

Clear the Data Share connection in Power BI and start again

If the Data Share connection in Power BI stops working, or you entered the wrong details, clear the saved credentials and connect again:

  1. In Power BI Desktop, go to File > Options and settings > Data source settings.

  2. Select the Amazon Redshift data source for Data Share.

  3. Click Clear Permissions.

  4. Follow "Connect Power BI Desktop to Data Share" again.

Why can't I connect Data Share to Power BI?

These are the common reasons a Data Share connection to Power BI fails.

  • Power BI can't reach the server. Check the server address exactly as the Assignar Data Team sent it, and that the database is assignar. If your company network blocks outside database connections, ask your IT team to allow the Data Share server.

  • The login is refused. Check the user name and password. If you changed them or entered them wrongly before, clear the connection (see above) and try again.

  • A feed you need isn't in the list. Your login only shows the feeds you have been given access to. Ask Assignar for access to that feed.

Related articles

Did this answer your question?