Start by adding a new report to a metric and selecting OneDrive as the data source. Instead of selecting a file from the list, scroll to the bottom of the connection window to find a text box where you can enter in the Share URL of the file in OneDrive. To get the Share URL in OneDrive, select the file you want to use and click "Share" at the top. For best results, follow these steps for configuring the Share URL:
Select Anyone with the link can edit to customize the link options.
- Set the option Specific people, enter your own name in the text box and select your account. Select Apply when you're done. **Note: the selected person must be part of the same organization in order for the link to work in Grow. If you see a message similar to the one in the screenshot below, the file will not be accessible to Grow.
- Once you're back at the main Share box, select Copy Link to copy the link to your clipboard.
- Paste the link it into the "Share URL" box in Grow: