• Navigate to https://make.powerautomate.com/ 
• Click Create on the left pannel
  • 
• Under the Start from blank section, choose "Automated cloud flow"
  • 
• Click on "Skip" as there is currently not a template for this
  • 
• (optional) When the Flow build workbench shows up, you may close the right CoPilot pain as it will not be needed
• (optional) This guide will be using the New Designer, choose the new designer if you want it to match your flow
  
  • 
• Click on "Add a Trigger"
• Choose under the Built-in tools section "Request"
  • 
• Choose "When an HTTP request is received" trigger from list of triggers
  • 
• Set the following in the trigger settings:
  • "Who can trigger the flow" : Anyone
  • "HTTP URL" : <nothing here as it will be generated after you save the flow>
  • "Request Body JSON Schema" : paste the contents to the schema text file attached here
  • "Advanced parameters" : choose Method from the list of check boxes
  • "Method" : choose POST from the drop down menu
  • 
• Back on the workbench click on the + icon and search for action "Response"
• Choose "Response" under the "Request" actions 
  • 
• Leave the settings as default with Status Code 200
  • 
• Save your Flow

Leave the Power Automate open as we will return after the next step (Create SharePoint Folder)

My suggestion is to save in a folder that is easy to find in your Team SharePoint site and the folder should not be used for anything other than the incoming date.  

• site url: https:\\[m365tenant].sharepoint.com/sites/[sitename]/Shared Documents/[subfolder(s)]
  • use for example: https:\\contoso.sharepoint.com/sites/PowerBi/Shared Documents/PowerBi/VOIP_CSR

• On the workbench click on the + icon and search for action "Parse JSON"
• Choose "Parse JSON" under the "Data Operations" Actions
  • 
• Click in the Content box and click on the lightning bolt
  • 
• From the flyout menu, choose "Body" from the "When and HTTP request is received" section
  • 
• Paste the same JSON schema from the text document attached
• Back on the workbench click on the + icon and search for action "Initialize Variable"
• Choose "Initialize variable" from the "Variable" actions
  • 
• Fill out the parameters for the Variable as such:
  • Name: "Event_Timestamp"
  • Type: "String"
    • 
  • For the Value, click on the box, then click on the fx under the lightning bolt on the right of the text box
    • 
  • Enter the following function:
    • string(body('Parse_JSON')?['data']?['event_timestamp'])
      • 
    • Click on Add at the bottom of the fly out box
      • 
• Back on the workbench click on the + icon and search for action "create file"
• Choose "Create file" from the "SharePoint" actions
  • 
• Set the Create file action parameters
  • 
    • Site address: Use the pulldown and either choose the site used earlier or enter the site URL: https:\\[m365tenant].sharepoint.com/sites/[sitename]
    • Folder Path: Use the folder icon on the right of the field to explore the SharePoint site for the folder created earlier.  
      • Note: The explorer will list all folders, so there will be some you have not seen before, always use folders under the "Shared Documents".  Any of the other root folders could cause data access, or other SharePoint issues.  
      • The ">" to the right of the folder name is the navigation link.  If you click on the folder name, it will choose that folder.  
      • 
  • 
    
    • File Name: Click on the text box then click on the lightning button to the right and choose "Event_Timestamp" under the "Variables" section
      • 
    • After you choose the Variable, type in ".json" after the code block in the text box.  
  • 
    • File Contents: Click on the text box then click on the lightning button to the right and choose "Body" under "Parse JSON"
      • 
• Now click on an empty part of the Flow workbench and click Save
• After the save is complete, click on the first step "manual" of your flow and copy the Webhook URL that it generated
  • 

• log into your Audian My VOIP portal
  • https://my.audian.com
• Click on the "waffle" menu button:
  • 
• Search for or select "Webhook" from the list of apps
  • 
• Click on "+ New Webhook"
  • 
• Fill the Webhook form:
  • Hook Name: [reconizable name for function] Used PowerBi-webhook for this example
  • Trigger Event: CDR
  • Version: v2
  • Optional: Include Sub Accounts
  • Request type: POST
  • Re-Try Attempts: 1
  • URL: [URL from the above step from Power Automate]
  • Body Format: JSON
  • Optional: Add Data Row
  • Optional: Tag to Group: Create grouping
  • 
• Click on Create Webhook

• Navigate to Power BI Blog—Updates and News | Microsoft Power BI 
• Click on the latest Blog post regarding "PowerBi [month] [Year] Feature Summary" 
• Download and install the latest version of PowerBi Desktop
  • You may need Administrator rights to perform the installation
• After installed, launch PowerBi Desktop and make sure to log into with an account on the same tenant as where the SharePoint data is located
• Create a new report

We have created a template to import our example PowerBI reports. 

It should get you started at importing the CSR JSON files you are receiving from the above steps.  

This template is provided as-is.  

• Download the attached file in this doc "Audian-VOIP-CSR-Log.pbit"
• Open PowerBi Desktop
• Click on "File"
• Click on "Import"
• Choose "PowerBi Template"
  • 
• In the file explorer, navigate to the downloaded template file and click "Open"
  • 
• There will be a pop up to enter some Parameters:
  • Required: 
    • pSPOSiteURL - This is the base SharePoint Team site URL from the above step where you created the SharePoint folder
      • example: https://contoso.sharepoint.com/sites/PlayingWithBI 
    • pSPOFolderURL - This is the folder and sub-folder address
      • example: https://contoso.sharepoint.com/sites/PlayingWithBI/Shared Documents/PowerBi/Audian_CSR/
        • NOTE - This URL is case sensitive and note the "/" at the end, it is required.
    • pTimeZoneMode - This sets your the Time Zone target you want your data localized to.  Defaults to PST and adjusts for both Standard and Daylight times
      • This is currently programed with the continental US Time Zones
      • We also have a manual offset option if you want to adjust to another offset.  Choose the "Fixed-Offset" option here then add your desired offset to the pFixedOffsetHours
  • Optional: 
    • pFixedOffsetHours - Fixed Time Zone offset if the pTimeZoneMode is set to "Fixed-Offset"
      • Defaults to 0 or UTC time.  
  • 
• Click on Load
• The Queries will start their data connections, this may take a little bit
  • 
• You may get a message to authenticate and to categorize the data source (Orginizational).  This may also show as an error that it cannot connect.  
• When it completes it should bring you to the reports
  • 
• Click on "Transform Data"
  • 
• Click on "Data source settings" 
  • 
• Confirm your SharePoint site is listed
• Click on "Edit Permissions..."
• Click on "Edit..." 
  • Click on "Microsoft Account"
  • Click on "Sign in as different user"
  • 
  • Complete the Microsoft OAuth 
  • Click on "Save"
• Set Privacy Level to "Organizational" 
• Click "OK"
• Click "Close"
• Click on the down arrow for "Refresh Preview "
• Click on "Refresh All" 
  • This will take a little bit
  • Once complete this should load all the data from the SharePoint files into PowerBi and show here in preview
• Click on "Close & Apply"
• This will begin the data load cycle and will take a little bit