topic Re: PowerBI SendGrid Content Pack Merged With SQL Server Data in Developer

PowerBI SendGrid Content Pack Merged With SQL Server Data

SachinC — Mon, 05 Sep 2016 16:55:11 GMT

Hi there,

I wish to connect to a SendGrid content pack and also merge this with data from SQL Server.

When I use PowerBI online (I cannot connect to SendGrid using PowerBI Desktop), I can only connect to SendGrid but cannot connect to another SQL Server repository at the same time - is this correct?

If the above isn't true, feel free to correct me.

Thanks in advance,

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

Anonymous — Mon, 05 Sep 2016 18:35:53 GMT

@SachinC In order to mash up data from two sources, you need to get that data into Power BI Desktop. In the case of SendGrid, there currently isn't an out fo the box connector in the Desktop. So, you would need to explore other connection options, such as Odata to connect to the SendGrid data, and also pull in your SQL data if you needed to combine the two data sets.

The Service won't allow you to do this (as you assume).

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

Eric_Zhang — Tue, 06 Sep 2016 08:51:39 GMT

@SachinC

In addition to @Anonymous, SendGrid has provided variable APIs to get data, check Using the Web API. A sample in that link is like

https://api.sendgrid.com/api/blocks.get.json?api_user=your_sendgrid_username&api_key=your_sendgrid_password

In this case, I think the "get data"->"other"->"web" can help to get data from Power BI desktop.

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

SachinC — Tue, 06 Sep 2016 21:59:12 GMT

Eric - excellent suggestion, but unless I am doing something wrong, that API connected through the method you specify in PowerBI desktop doesn't open up the data source properly. Can you help? You are getting very close....

Thanks.

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

Eric_Zhang — Wed, 07 Sep 2016 01:55:08 GMT

@SachinC wrote:

Eric - excellent suggestion, but unless I am doing something wrong, that API connected through the method you specify in PowerBI desktop doesn't open up the data source properly. Can you help? You are getting very close....

Thanks.

@SachinC

What do you mean "doesn't open up the data source properly"? What is wrong in your case?

I don't exactly know the SendGrid APIs, regarding the so called "data source", I think you would put more effort on researching the APIs.

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

SachinC — Wed, 07 Sep 2016 07:59:50 GMT

Hi,

Using the API web call string, it authenticates, however I only get Kind, Name and Text (no idea what this means). I was looking for the usual fields - i.e. #Sent, #Bounced, #Spam etc...

That's why this has thrown me!

Regards,
S

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

Eric_Zhang — Wed, 07 Sep 2016 08:13:42 GMT

@SachinC wrote:

Hi,

Using the API web call string, it authenticates, however I only get Kind, Name and Text (no idea what this means). I was looking for the usual fields - i.e. #Sent, #Bounced, #Spam etc...

That's why this has thrown me!

Regards,
S

So the web source already works.

You shall dig into the APIs to find out the ones that would return required data in your case. Regarding any question on SendGrid APIs, SendGridis official site is a proper place and you will get better response there.

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

SachinC — Thu, 08 Sep 2016 10:24:25 GMT

Hi,

SendGrid have confirmed the API URL only contains a small element of what I need. They will confer internally with their developers.

I am now snookered on what to do next?

To recap, I want to mashup SendGrid & MS SQL data sources in one report / dashboard using PowerBI. To go a level further, I may want to introduce Google Analytics into this, but for the moment the core focus is on SendGrid and SQL.

Thoughts anyone?

Thanks,

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

Eric_Zhang — Fri, 09 Sep 2016 02:10:28 GMT

@SachinC wrote:

Hi,

SendGrid have confirmed the API URL only contains a small element of what I need. They will confer internally with their developers.

I am now snookered on what to do next?

To recap, I want to mashup SendGrid & MS SQL data sources in one report / dashboard using PowerBI. To go a level further, I may want to introduce Google Analytics into this, but for the moment the core focus is on SendGrid and SQL.

Thoughts anyone?

Thanks,

S

I think you're pending on SendGrid, SQL Server is always ready for Power BI. Regarding anything next to do, maybe ask the SendGrid for any other way to get the usual fields - i.e. #Sent, #Bounced, #Spam etc. Does the content pack in Power BI service contains the all the fields required? If yes, expect the API way, there shall be some other programmable approach.

Re: PowerBI SendGrid Content Pack Merged With SQL Server Data

PBILover — Tue, 06 Oct 2020 14:14:25 GMT

@SachinC are you able to accomplish this?