Previous Article | matchIT SQL Index | Next Article |
In order to use Power BI reporting in your stored procedures you need to modify the <PowerBISettings> setting under the <reports> node in your config file. In this node you can set your Job Name and also the connection string for where Power BI will need the data from the processing to be stored (by default in SSIS this would be in the "matchIT_SQL" database.
<PowerBISettings jobName="" connectionString="" />
Once configured you are ready to run your Stored Procedures.
For all information on using PowerBI, please click here.
Previous Article | matchIT SQL Index | Next Article |