DW_logo

Microsoft_PowerBI_logo
Microsoft Power BI
RCH Stock on the Toronto Stock Exchange with
Automatic Refresh using Power BI Report Server
by Eric Tremblay

Version 1.0

     Quincaillerie Richelieu Ltèe. Dashboard by Eric Tremblay
This Power BI solution is for reporting on the Richelieu Hardware Ltd.
RCH Stock Price on the TSX Toronto Stock Echange. Also, confirguration
of the Power BI Report Server.

This is for the RCH Stock on the Toronto Stock Exchange
It can be any stock on the TSX, you only need to change a couple of things

Test the current version before doing any modifications
Press the Refresh button to update the data



     Click Image to Enlarge


RCHRefresh

pibx-file-icon
Click to download


     Microsoft Power BI Richelieu Hardware Ltd. (RCH.TO) iPad View
RCH_SS


Microsoft_PowerBI_Mobile_Icon

     Microsoft Power BI Richelieu Hardware Ltd. (RCH.TO) for Mobile

IP_RCH_1 IP_RCH_2 IP_RCH_3


     Modify for another Stock validate that everything is
working well then... modify for your stock of interest.

Before you start make sure your URL is correct
Test them in a web browser


Click here for RCH TSX
Click here for BBD.B TSX


     1: Stock name from RCH to BBD.B for example
In the Edit Queries, select Data source setting
in the URL box, change only the stock symbol from
RCH to BBD.B for example


RCHDataSource1

RCHDataSource2


     2: In the MeasuresTable

Change

The Stock Name

Title Symbol = "RCH" to Title Symbol = "BBD.B"

Title Name En = "Richelieu Hardware Ltd. (RCH.TO)"
to
Title Name En = "Bombardier Inc. Class B Subordinate Voting Shares"

Title Name Fr = "Quincaillerie Richelieu Ltèe. (RCH.TO)"
to
Title Name Fr = "Bombardier Inc. Class B Subordinate Voting Shares"

Change the company logo, if you wish …



RCHStockName


     3: Automatic Refresh using Power BI Report Server
If you have a Power BI Report Server
You can schedule a refresh to keep the stock price upto date.
Configure the Data source


RCH_PBIServer_A


     Create a refresh schedule
RCH_PBIServer_B

RCH_PBIServer_C


     It's done, Enjoy !!!






FluidBlocks_Icon32
Designed with Fluid Blocks