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

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!

    • PBILover's avatar
      PBILover
      Helper V
      6 years ago

      DazBox_za  Thank you very, this solution works!!

      but i can see only email statistics reports , how to get data for SMS from sendgrid?

      Is there any PBIT/PBIX file for that?

       

      Thanks,

      Namita

    • kapcreations's avatar
      kapcreations
      New Member
      4 years ago

      I've searched the web on how to get SendGrid data into Power BI and was lead to this post. However, I'm unable to get it to work.

       

      I've followed the steps outlined in the above posts but never get prompted to log in when opening the pbit file.

  • 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.

  • ldrivinghawk's avatar
    ldrivinghawk
    Advocate I
    9 years ago

    Thank you!

  • gscara's avatar
    gscara
    Frequent Visitor
    8 years ago

    Hi

    I tried the solution that you posted and was unable to download any SendGrid data.  I assume that I have to modify the .m file to enter my SendGrid credentials or should the PowerBI file be asking me to provide these.

     

    Thanks in advance.

     

     

    • spawnian's avatar
      spawnian
      Frequent Visitor
      7 years ago

      Did not work for me either..

       

      Anyone get this working, or detailed steps required to do so ?

  • PBILover's avatar
    PBILover
    Helper V
    6 years ago

    After following above process, got below error

    'Fields that need to be fixed'

    Please suggest

     
     
  • PBILover's avatar
    PBILover
    Helper V
    6 years ago

    Thanks v-qiuyu-msft , This PBIT file gives email statistics.

    Do we have any other PBIT or PBIX which will give us SMS reporting capabilities?

     

    Thanks,

    Namita

    • PBILover's avatar
      PBILover
      Helper V
      5 years ago

      Hi can we get the sendgrid data without any aggregation by using mentioned template files. 

      Currently data is aggregated by day.

      DazBox_za ,