topic Re: SAS EG connecting with Power Bi in Microsoft Integration with SAS

SAS EG connecting with Power Bi

dtravassos — Sat, 08 Jun 2019 22:53:35 GMT

Hello All,

I have sas eg running local. Also power BI reading a ODATA data source. Would be possible to SAS EG to read power BI data in any way?

Thank you very much

Danielle

Re: SAS EG connecting with Power Bi

Reeza — Sun, 09 Jun 2019 01:52:55 GMT

You can connect SAS to the OData source directly, not sure about PowerBI.

Re: SAS EG connecting with Power Bi

SASKiwi — Sun, 09 Jun 2019 09:04:27 GMT

PowerBI data is read in from other sources which SAS can read like SQL Server, Excel, other ODBC sources etc. SAS EG can read all of these.

Re: SAS EG connecting with Power Bi

dtravassos — Mon, 10 Jun 2019 15:20:07 GMT

Hi,

Reeza. That would be wonderful. How do I do that?

Re: SAS EG connecting with Power Bi

Reeza — Mon, 10 Jun 2019 15:24:54 GMT

It depends exactly on how the feed is set up, but here's a post from Socrata that discusses this:

https://dev.socrata.com/blog/2015/11/10/analyzing-open-data-with-sas.html

Re: SAS EG connecting with Power Bi

dtravassos — Mon, 10 Jun 2019 15:26:47 GMT

Hi SASKiwi,

Yes, Agreed. I can access the DB through Squirrel SQL using a JDBC adapter and power BI via Odata. But I can't directly access using SAS because SAS provides interface with ODBC but not with JDBC. I got a trial for the tool SAS/ACCESS interface with JDBC but it's not working for me. I read on the SAS website that the JDBC interface only works with SAS Viya, not sure about EG.

If I could connect my SAS EG via ODATA or read the power BI tables directly or somehow with our DB with JDBC, that would solve my problem. Currently, I have to export from Power BI and import to SAS.

Re: SAS EG connecting with Power Bi

dtravassos — Mon, 10 Jun 2019 15:40:18 GMT

Hi Reeza,

I read that article previously, however, from what I understood, it helps you to import data coming from one single file. I have a database with multiple tables. Ideally, I would be able to see and query all the table directly, like a library.

Thank you

Danielle

Re: SAS EG connecting with Power Bi

Reeza — Mon, 10 Jun 2019 16:19:40 GMT

OData sources usually aren't set up in that fashion, AFAIK, do you have an example of that set up?

Re: SAS EG connecting with Power Bi

SASKiwi — Mon, 10 Jun 2019 20:20:01 GMT

SAS/ACCESS to JDBC is available in SAS 9.4M6 released Nov 2018. Just would work with EG. What's your SAS 9.4 maintenance level?

Re: SAS EG connecting with Power Bi

Walker_cabay — Fri, 13 Dec 2019 10:29:00 GMT

Power BI provides cloud-based BI services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop".