https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805882#M40505 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. Mon, 04 Apr 2022 16:10:27 GMT d9n9 2022-04-04T16:10:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805882#M40505 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. Mon, 04 Apr 2022 16:10:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805882#M40505 d9n9 2022-04-04T16:10:27Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805939#M40506 <P>PowerBI connects to data. SAS EG is an application.</P> <P>So the questions is - where does your data reside which you access from EG?</P> <P>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.</P> Mon, 04 Apr 2022 21:12:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805939#M40506 LinusH 2022-04-04T21:12:09Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805941#M40507 <P>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.</P> Mon, 04 Apr 2022 21:19:10 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805941#M40507 SASKiwi 2022-04-04T21:19:10Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805949#M40508 SAS server is not required to read a SAS dataset. Only the SAS ODBC driver. Mon, 04 Apr 2022 21:40:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/805949#M40508 AlanC 2022-04-04T21:40:18Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/807224#M40530 <P>The table one creates in SAS EG is essentially a SAS dataset.<BR />It is simpler to import data into Power BI. The following reference has the details of importing the data.<BR /><A href="https://businessintelligist.com/2016/09/09/reading-sas-sas7bdat-files-in-power-bi/" target="_blank">https://businessintelligist.com/2016/09/09/reading-sas-sas7bdat-files-in-power-bi/</A>&nbsp;</P> <P>&nbsp;</P> Mon, 11 Apr 2022 18:42:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/807224#M40530 Sajid01 2022-04-11T18:42:30Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/807288#M40532 <A href="https://documentation.sas.com/doc/en/odbcdref/9.4/p1esd8t7nrdvmfn1guh905g1dnvk.htm" target="_blank">https://documentation.sas.com/doc/en/odbcdref/9.4/p1esd8t7nrdvmfn1guh905g1dnvk.htm</A> Tue, 12 Apr 2022 06:49:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Connect-created-table-with-data-from-SAS-EG-to-POWER-BI/m-p/807288#M40532 LinusH 2022-04-12T06:49:54Z