Venus Control Suite Data Studio: How do I grant access for my online spreadsheet source?

Topic

This article outlines how to grant access to an Online Spreadsheet data source in Data Studio. Access is provided through secure authentication (OAuth) when connecting to Microsoft Excel (OneDrive) or Google Sheets, allowing Data Studio to read and use the selected file.

Environment

  • Product Family: Venus Professional, Venus Enterprise, Venus Live
  • Product: Data Studio
  • Component: Online Spreadsheet Data Source
  • Control System: Venus Control Suite (Cloud Hosted)

Steps

▶️Use the arrows to expand and collapse each section.

Grant Access to an Online Spreadsheet Source
  1. When adding an Online Spreadsheet in Data Studio, select your Provider (Microsoft or Google)
  2. Click Login to begin authentication
  3. Enter your account credentials
    • Complete multi-factor authentication if prompted
  4. Review the requested permissions
  5. Click Accept to grant Data Studio access to your account

Note: Granting access allows Data Studio to securely read your selected files using OAuth authentication.

 

  • Microsoft Example below:

When launching from Data Studio.png

 

Data Studio Access Email (If Prompted)
  • You may be prompted to verify your account during login
  • Follow the instructions provided to complete the process

Microsoft Example below:

Email about granting access.png

Microsoft Account Access (If Needed)

If you need to review or confirm app access, you can manage connected apps in your Microsoft account: https://account.microsoft.com/privacy/app-access

  • Open the Security tab on your Microsoft account

Showing Data Studio as an App with access.png

Showing what permissions Data Studio has.png

 

Related Resources
Venus Control Suite Data Studio: Unable to add an Online Spreadsheet source, error “We’re unable to complete your request”
Venus Control Suite Data Studio: How do I integrate with an online spreadsheet or calendar on a Venus cloud hosted system?
Venus Control Suite Data Studio: How do I configure data trimming?

KB ID: 000028613

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.