...
Setup Sharperlight:
Ensure Sharperlight is installed and properly configured to interact with the Workbench database.
Define and configure the data models within Sharperlight to align with the reporting requirements.
Data Security and Performance:
Use Sharperlight to manage data access permissions and ensure secure data handling practices.
Utilize Sharperlight’s capability to abort slow-running queries and to stage data for long-running operations to maintain system performance.
Methods to get data from Sharperlight
There are two ways to communicate between PowerBI and Sharperlight
Custom Connector (PQX) file
Using plain JSON Sharperlight Output.
The Custom Connector (PQX) is much more challenging to setup and maintain. We recommend using the JSON approach where possible. It allows end users to refresh to get the latest data from the Web and scheduled refresh can also be setup.
Both methods take snapshots of the query data and will need to be refreshed to get the latest report structure or data.
Guidelines for Effective Use
...