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?
... View more
