Connect created table with data from SAS EG to POWER BI

[d9n9]

Is there any way to create connection between dataset from specific table in SAS Enterprise Guide 8.3 to POWER BI desktop app? I want to create connection that will automatically update data in POWER BI and graphs also after running skript.

[LinusH]

PowerBI connects to data. SAS EG is an application.

So the questions is - where does your data reside which you access from EG?

Generally speaking, you need either a local SAS Foundation installation, or a SAS server that acts like an ODBC server. If using ODBC, you need a SAS ODBC driver.

[AlanC]

SAS server is not required to read a SAS dataset. Only the SAS ODBC driver.

[LinusH]

https://documentation.sas.com/doc/en/odbcdref/9.4/p1esd8t7nrdvmfn1guh905g1dnvk.htm

[SASKiwi]

We have found the easiest way to get SAS data into Power BI is to load the tables into SQL Server which Power BI can easily access. If you are just doing this on a single PC then writing out a CSV data file in SAS and importing that into Power BI is an option.

[Sajid01]

The table one creates in SAS EG is essentially a SAS dataset.
It is simpler to import data into Power BI. The following reference has the details of importing the data.
https://businessintelligist.com/2016/09/09/reading-sas-sas7bdat-files-in-power-bi/