Solver’s Power BI connector, also referred to as the External API, is a certified connector providing a link between your Solver tenant(s) and Power BI. The connector utilizes the Solver API to access data from the Solver Data Warehouse. The Solver API handles the data preparation for the Power BI connector.

Power BI version:
This guide is built using Power BI Version:

• Version: 2.68.5432.661+ 64-bit (April 2019). The April or newer version of Power BI desktop is required. Learn about Power BI Desktop here: https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop

Getting Started

This section will detail enabling the Solver External API connector and connecting to Power BI.

1. Download and install Power BI desktop. Start here: https://powerbi.microsoft.com
2. Once Power BI desktop is installed, navigate to your Solver tenant.
3. From the Solver main menu, click Data Warehouse→ Configuration→ API  
   • Users must have “Can manage Data Warehouse configuration” permissiosn
4. Click the toggle to Enable the API
   
5. Select the modules that you would like to make available to the API and click Save in the upper right hand corner.
   
6. Click on the gear icon will provide you with the URL and Access token needed when connecting Solver to Power BI desktop, detailed in the next section.
   

Connecting to Solver and Loading Data

The following steps take place from within Power BI Desktop.

1. From the Power BI ribbon, click Get Data.
2. Type in “Solver” to find the Solver data connector and click Continue.
3. Power BI is asking for the API URL. This can be found in Solver (Configuration > Configuration > API)
   
   
   Paste in the URL and click Ok.
4. Power BI will now prompt for the Access Token. This can be found in Solver.
   
   
   Paste in the Access Token and Click Ok.
5. Assuming the provided material is correct, Power BI will successfully connect to your tenant an a listing of all dimensions and modules that you have enabled will appear. At this point, you can begin creating dashboards and visuals in Power BI.

Assuming the provide token and URL are valid, Power BI will successfully connect to your tenant an a listing of all dimensions and modules you have enabled will appear. At this point you can begin creating dashboards and visuals in Power BI.

Access Token Validity

Access tokens are per user. Any user with Can manage configuration can create an access token. With this, it is strongly recommended to limit those who can “Manage The connection in Power BI remains valid unless one of the following is done.

1. Credentials are removed in Power BI.
2. The account is disabled in Solver.

• Select the modules and related dimensions to import into Power BI and click the Load button.

Module & Dimension Relationship

Selecting to expose a Module within the Solver API, will automatically include the related dimensions. To review the dimensions mapped to each module, navigate to the Solver Overview page. The Overview page displays every module and related dimensions.

• Data will begin loading for each module and dimension selected. This may take several minutes, depending on the amount of transactions available in the module.
  
  Please note that size limitations do exist, depending on the version of Power BI desktop used. 

Managing Power BI Desktop Connector

Updating the Solver API

If changes are made to the modules or dimensions, for instance if a new attribute is added, deleted or edited, the API will need to be updated to reflect the changes.

• Note: Changes to the Data Warehouse structure may break existing Power BI dashboards. For example, if a dimension or attribute name used in a dashboard is changed or deleted, the dashboard will error.

To update the API in Power BI:

1. From within Solver Cloud, navigate to the API screen, under the Data Warehouse > Configuration menu.
2. Unselect the Module(s) which contain the changes and click the Save icon.
3. Reselect the Module(s) which contain the changes and click the Save icon once again.
   
   This will update all related dimensions and views to include the latest changes. This includes related dimensions added, removed or edited as well as dimension and module attributes added, removed or edited.
4. To refresh Power BI desktop with the latest data within Solver, click the Refresh button on the Power BI ribbon. This will refresh all data as well as any changes to the Dimensions and Modules selected

Refreshing Data in Power BI Desktop

To refresh an individual dimension or module, on the far-right FIELDS section, click the … and select Refresh data.

Publish Dashboard to Power BI Cloud

Once a Dashboard or other visualization is created in Power BI Desktop, the results can be published to the Power BI web application.

• Save the current desktop Dashboard.
• Click on the Power BI Home ribbon and select Publish to share the dashboard.
• The prompt will display available destinations based on your Microsoft Power BI user.

• Power BI Desktop will publish the report and related data set to Power BI.

Refreshing Data in Power BI Web Application

Once the report is published to the Power BI web application, the data can be refreshed manually or scheduled directly from the Power BI web application.

Note: To refresh the data directly from the Power BI web application, you will need your Solver API Access Token. The token is found on the API page within Solver.

To manually refresh or schedule a refresh, follow these steps:

1. Log into the Power BI web application https://app.powerbi.com
2. Expand the My Workspace section to reveal the DATASETS you have published
3. To refresh a dataset, click on the … to the right of the data set.
4. Click the REFRESH NOW option

Note: You will receive an error the first time you click refresh, follow these steps to configure the permissions

• Click Close to continue to add the correct permission. You will be redirected to the Dataset management page. Click the Edit credentials link.

• The Account Key is required. To get the Account key, navigate to your Solver tenant -> Data Warehouse -> Configuration -> API page and click the gear icon in the upper right to copy the Access Token.

• Select the privacy level for the dataset. Learn more about privacy levels here: https://docs.microsoft.com/en-us/power-bi/desktop-privacy-levels
• Click Sign in to connect to Solver Cloud.
• You can now manually refresh or schedule a refresh from within Power BI.
• To learn more about scheduling a refresh, follow this link: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
• You can also view the Refresh history, including refreshes in progress from the Datasets menu.

Appendix

Additional Resources

1. Getting Started with Power BI: https://docs.microsoft.com/en-us/power-bi/desktop-getting-started

Troubleshooting

1. Solver Connector does not show in Power BI Desktop.

Try the following:

1. Ensure that you are running the latest version of Power BI Desktop

Common Questions

1. How do I post feedback?
   Within Solver, click the Feedback button on the upper part of the screen. Note that the feedback is for Power BI and/or API and enter comment.
2. What is the cost of the Solver – Power BI connector?
   The Power BI connector is the same price as other Data Connectors found on the Solver order form.
3. Is the data filtered based on the users data access rights configured within Solver?
   Not at this time. It will be considered for a future release. Data access limitations can be managed within Power BI.
4. Is the API key by tenant or by user?
   The Authentication is stored by user account. This key should be kept private as it is the authentication to the Solver API.
5. Do I need to select the dimensions associated with the module?
   In order to import the related dimensions and attributes, they must be selected in the Navigator. However, the modules can be imported without selecting the related dimensions, if desired. The benefits of selecting the dimension(s) is that the visualizations can be built based on the dimension attributes. For example, if the chart should be based on the Entity description, not just an Entity code, the dimension must be selected in the Navigator.
6. Are the Dimensions automatically joined to the modules?
   Yes. The connector includes logic to map each related dimension to the selected module using the “dimension code” field. However, the dimensions must be selected to be included in the import on the Power BI navigator screen. 
7. Can I use the API to access Solver data from other applications besides Power BI?
   Direct access to the API (other than Power BI) is not currently supported. It is on the roadmap and expected to be made available near or soon after the general availability of the Power BI connector. 
8. Does the Solver API would for other Data Visualization applications like Tableau?
   The Solver product team is reviewing connectors from other popular visualization applications.

Appendix

Solver Support

The Solver Support Center (support.solverglobal.com) is the central location for users to learn more about the Solver Suite. From opening and managing your support tickets to reading knowledgebase articles about the product, the Solver Support Center has everything a user will need.

Users may contact Solver Support if they have questions about the Solver Suite. One of our technical support consultants will gladly assist you.

Solver Academy

The Solver Academy is an eLearning subscription based learning platform for Solver users to access. Users can find detailed video material on many Solver Suite features along with training material and certifications. To begin, visit academy.solvertraining.com.