Using PBRS
      Back to home
      1. Knowledge Base
      2. PBRS
      3. Using PBRS

      How do I set up a Google Sheets Destination in PBRS?

      Using Google Sheets you can export Power BI Service Reports & Dashboards directly to Google Sheets.

       

      This article applies to:

      • Power BI Reports & Dashboards (Cloud - Power BI Service)

      Destinations - Google Sheets

      In the Schedule Wizard, go to Destinations.

      pbrs destination set up-1

      • Click Add and select Google Sheets.

      pbrs destinations

       

      Power BI and SSRS Reports: Google Sheets Destination in PBRS.

      • Google Sheets allows you to send the report via Google Sheets which can be accessed on any server with the user credentials.
      • Google Sheets Account: Select the account.
        • If there's no account added, click Add New Account.

      For more information about adding a Google Sheets account, click here.

      Power BI and SSRS Reports: Google Sheets Destination in PBRS.

      Output Format

      The only output format available in the Google Sheets destination is Google Sheets.

      Power BI and SSRS. Google Sheets Destination Wizard in PBRS

      • To add visual data click Add.

      Power BI and SSRS. Google Sheets Destination Wizard in PBRS

      • Visual Title: Select the Visual data's titles you want to export.

      In order for PBRS to see a Visual, the Visual MUST have a title already set in Power BI.

      • Data Export Type
        • Summarized data: Select this option if you want to export data for what you see in that visual.
        • Underlying data: Select this option if you want to see the data in the visual and additional data from the model.

      For more a more detailed explanation of the Data Export Types, click here.

      • Click OK.