Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To update your reports, install Power BI Desktop on your workstation and contact Intlock Support to allow temporary access from your workstation's public IP address to the CardioLog Analytics SaaS Azure SQL database.

 In order to link connect your custom reports to the new datasets (by quarters), follow the instructions below:

  1. Open your custom report in Power BI web service and download the report .pbix file by clicking File > Download the .pbix file.



    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 and click on Transform data > Data source settings Sign in.
    Image Removed
    Click on Change Source… confirm that the Server and Database names are correct. Contact Intlock Support to receive your database details.
    Image Removed
    Expand Advanced options and confirm that the Command timeout in minutes is 240 and Enable SQL Server Failover support is enabled. Click OK > Close.
    Image Removed
    Image Added

  3. Enter your Power BI Pro account which is the owner of the CardioLog Analytics SaaS workspace and click Sign in.

    Image Added

  4. Open Power Query by clicking on Transform data > Transform data.



  5. On the

    left

    left Queries

    pane

     pane, select

    the 1 – SharePoint Usage table and open the Advanced Editor popup window by clicking on Advanced editor.
    Image Removed
  6. Edit the query and add _Q1 at the end of V_PBI_FactEventLogAndSocialActivity_V1023_Q1. Click Done.

  7. Repeat steps 6 and 7 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 Removed
    Save your changes by clicking on all items by clicking the top Parametars folder, holding the Shift key in the keyboard, scrolling down the list and clicking on the last table item under the Other Queries folder. Right click and select Delete.

    Image Added  

  8. Accept deleting all queries and groups by clicking on Delete.

    Image Added


  9. Publish the custom report to Power BI web service by opening the CustomReportName_Q1.pbix file and clicking

    Save your changes by clicking on Close & Apply > Close & Apply.
    Image Removed
    The SQL Server Database popup window will appear. Enter the User name and Password and click Connect to apply query changes. Contact Intlock Support to receive your database credentials. 
    Image Removed

    On the top ribbon click on Refresh, the data refresh process will start immediately and may take a few minutes. 

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

  11. Copy the CustomReportName_Q1.pbix file and create 3 additional files named CustomReportName_Q2.pbix, CustomReportName_Q3.pbix, CustomReportName_Q4.pbix.

  12. Open each file and repeat steps 5 - 9 (Power BI will remember your database credentials). Edit the query for each table and add the proper extension _Q2, _Q3, _Q4 accordingly.
  13. Click on Refresh and save the .pbix file.
  14. Note: After saving your changes all report visuals will appear broken. They will be loaded properly after completing the next steps 8 - 11.

    Image Added

    Image Added

  15. On the right Fields pane, delete all tables by clicking on the ... button to the right of each table name to expand the More options menu and select Delete.

    Image Added

  16. Confirm deleting each table by clicking on Delete.

    Image Added

  17. Link the report to the new Q1 dataset by clicking on Power BI datasets.

    Image Added

    Note: If you get the following error message after clicking on Power BI datasets, repeat steps 5 - 9 and make sure you have deleted all queries and fields.

    Image Added

  18. Select the new CardioLog Analytics SaaS dataset for Q1 in the Select a dataset to create a report popup window and click Create. The data refresh process will start immediately and may take a few minutes. 

    Image Added

  19. Click File > Save as and save the file as CustomReportName_Q1.pbix.

  20. Publish the custom report for Q1 to Power BI web service by clicking on Publish. Enter your CardioLog Analytics SaaS workspace in the Publish to Power BI popup window and click Select. Once the publish process is done your custom report will be available in the Power BI web service.
  21. Repeat step 16 for CustomReportName_Q2.pbix, CustomReportName_Q3.pbix, CustomReportName_Q4.pbix.
  22. Connect your custom report to the remaining datasets for Q2Q3Q4 by clicking on Transform data > Data source settings and repeating steps 11, 12, 13 for each quarter.

    Image Added


  23. Repeat steps 1 - 17 14 for each custom report.
  24. In order to confirm that all of the steps above were performed correctly, you can see which reports are connected to each dataset in Power BI web service by expanding your CardioLog Analytics SaaS workspace > Datasets > click on the ... button to the right of each dataset and select View lineage.

    Image Added