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

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 

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