topic Re: SAS VIYA4 integration with MS Power BI in Microsoft Integration with SAS

SAS VIYA4 integration with MS Power BI

Tomasz_Barnas — Wed, 08 May 2024 08:48:36 GMT

Due to an unusual specification, I need to make a connection between SAS VIYA4 and MS Power BI.
I have found solutions to create this type of connection between SAS 9.4
Unfortunately, on the forum and on the Internet I do not see any valuable materials on this type of connection from the VIYA system.
An additional complication is that the connection must be made by downloading data from IN-Memory tables, but if this is impossible I would like to get any connection.
In summary, the in-memory tables sas VIYA4 is the source of the data and Power BI analyzes it.
I was wondering if it is possible to use SAS OLPA SERVER for this, to integrate the data contained in SAS VIYA with MS Power BI. Moreover, OLAP SERVER is a desktop tool. I do not hide the fact that ideally there would be an alternative tool running in an on premise solution on the browser side.
I am aware of the differences between VIYA and SAS 9.4, and how this idea sounds.
The question is do you have any ideas on how to get around any associated inconvenience?

Re: SAS VIYA4 integration with MS Power BI

Berux — Wed, 08 May 2024 08:50:17 GMT

I have the same issue, please help

Re: SAS VIYA4 integration with MS Power BI

JuanS_OCS — Wed, 08 May 2024 10:17:25 GMT

Hello @Tomasz_Barnas , @Berux ,

I will give you the architectural considerations. Towards implementation, feel free to visit the documentation at SAS.

Please note, SAS OLAP server is a 9.4 technology, not available in SAS Viya (3.5 or 4).

This being said, any tool can access SAS Viya capabilities via Rest APIs, and or SAS Jobs (also accessible via Rest APIs).

When in SAS 9.4, you would need common http requests and/or the usage of SAS Stored Processes - which can be published in the web application SAS Stored Processes and/or as webservice.

In this sense, PowerBI or any other tool can use the capabilities from SAS Viya (more capabilities) and of SAS 9.4

I hope this helps to give you some direction about what aspect of the documentation to look into.

Re: SAS VIYA4 integration with MS Power BI

Sajid01 — Mon, 18 Nov 2024 22:33:55 GMT

Hello @Tomasz_Barnas
The feasible option for in this instant is to export the data to a csv or Excel file and then import into PowerBI.
As a FYI in memory table data is actually a memory mapped data.

Re: SAS VIYA4 integration with MS Power BI

SASKiwi — Tue, 19 Nov 2024 03:18:14 GMT

I've found that the easiest way to supply SAS data to Power BI is via SQL Server. In my experience, most Power BI users have SQL Server available as a data source, so it is very easy to use SAS 9.4 SAS/ACCESS to SQL Server or SAS Viya 4 SQL Server connector to get data from SAS to Power BI.