Forum Discussion

ldrivinghawk's avatar
ldrivinghawk
Advocate I
9 years ago
Solved

Sendgrid Connection For Desktop Version

Hi there,

 

Wondering why the sendgrid connection is available for the online version but not the desktop version.

Content Packs
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi ldrivinghawk,

     

    Currently, Power BI desktop doesn't provide built-in Sendgrid connector. You can download Sendgrid template files and .m file from here:

     

    - Install the latest PBI Desktop 
    - Create a folder called Extensions under: C:\Program Files\Microsoft Power BI Desktop\bin 
    - Copy the .m file to that folder 
    - Set these 2 environment variables in Windows: 
       PQ_EnableExtensionDeveloper = true 
       PQ_ExtensionDirectory = C:\Program Files\Microsoft Power BI Desktop\bin\Extensions 
    - Open the PBIT file

     

    Best Regards,
    Qiuyun Yu

14 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi ldrivinghawk,

     

    Currently, Power BI desktop doesn't provide built-in Sendgrid connector. You can download Sendgrid template files and .m file from here:

     

    - Install the latest PBI Desktop 
    - Create a folder called Extensions under: C:\Program Files\Microsoft Power BI Desktop\bin 
    - Copy the .m file to that folder 
    - Set these 2 environment variables in Windows: 
       PQ_EnableExtensionDeveloper = true 
       PQ_ExtensionDirectory = C:\Program Files\Microsoft Power BI Desktop\bin\Extensions 
    - Open the PBIT file

     

    Best Regards,
    Qiuyun Yu

    • DazBox_za's avatar
      DazBox_za
      Frequent Visitor
      6 years ago

      For anybody struggling with this, these two additional steps should solve your problems:

       

      1. Open Power BI Desktop. Go to File  --> Options and Settings --> Options --> Security
        • Under "Data Extensions" select the second "not recommended" option to allow extensions to load without validation
        • Select "OK"
        • Close Power BI
      2. Copy the .M file provided to user\Documents\Power BI Desktop\Custom Connectors

       

      Open up the provided PBIT file after this, and you should be prompted to enter your SendGrid login details

      gscara spawnian PBILover keribeal 

      • keribeal's avatar
        keribeal
        Regular Visitor
        6 years ago

        Works like a charm, used it to dump 3 years worth of stats out of a send grid account i'm about to close.

         

        Thanks for your help!

    • keribeal's avatar
      keribeal
      Regular Visitor
      6 years ago

       Hi v-qiuyu-msft how to i set a username & password or API key for this to get my data?

       

      The template loads ok but shows no data or prompts for credentials.

       

      Thanks in advance.