Page History

...

How does this affect you?

Out of the box Power BI reports are updated automatically. Custom reports and/or out of the box report copies should be updated manually.

...

How to prepare for this change?

Custom reports and report copies :will be broken after the update:

To fix a broken visual, edit the report by clicking the Edit button, select the broken visual which currently uses the removed column/measure and replace it with the new/updated column/measure.


Prerequisites

1. Install Power BI Desktop on your workstation.
2. Contact Intlock Support to allow access from your workstation's public IP address to the CardioLog Analytics SaaS Azure SQL database.

In version 1.0.29, you can choose to split the CardioLog Analytics SaaS dataset to several datasets (by quarters) in order to reduce the dataset size and improve performance. In order to link your report copies custom reports to the new datasets, follow the instructions below to update your reports:below:

1. Open the custom report in Power BI web service and download the report .pbix file by clicking File > Download the .pbix file
   
   Image Added
   
   Note: In case the .pbix file fails to download due to the dataset size, contact Intlock Support.
   
   

2. Open the .pbix file in Power BI Desktop. Open Power Query by clicking on Transform data > Transform data.
   
   Image Added
   
   

3. On the left Queries pane, select the 1 – SharePoint Usage table and open the Advanced Editor popup window by clicking on Advanced editor.
   
   Image Added
   
   

4. Edit the query and add _Q1 at the end of V_PBI_FactEventLogAndSocialActivity_V1023_Q1. Click Done.

5. Repeat steps 3 and 4 for the following tables:
   5 - SharePoint Usage | Visits - add _Q1 at the end of V_SSAS_Visits_Q1
   5 - API | Custom Events - add _Q1 at the end of V_ExtendedApiMetadata_Q1

   Image Added
   
   

6. Save your changes by clicking on Close & Apply > Close & Apply.
   
   Image Added
   
   

7. Edit the dataset source by clicking on Transform data > Data source settings.
   
   Image Added
   
   

8. Click on Change Source… enter the Server and Database names and click OK > Done. Contact Intlock Support to receive your database details.
   
   Image Added
   
   

9. On the top ribbon click on Refresh, enter the User name and Password in the SQL Server Database popup window and click Connect. The data refresh process will start immediately. Contact Intlock Support to receive your database credentials. 

   Image Added 

    

10. When the data refresh process is complete, save the file as CustomReportName_Q1.pbix.

11. Create 3 additional files from “Name_Q1.pbix” and named them “Name_Q2.pbix”, “Name_Q3.pbix”, “Name_Q4.pbix”.

Version 1.0.29 - October 2020

...