Gateway for SAS Datasets

[Akshay6478]

I'm working with a Microsoft PowerBI file that sources its data from SAS datasets located on a shared Azure network drive. I'm curious if there's a method to refresh the PowerBI reports directly via the PowerBI service, utilizing a gateway for these SAS datasets. While I've successfully established a gateway connection for Excel files, I'm encountering challenges in setting up a similar connection for the SAS datasets. Any insights or guidance on achieving this would be greatly appreciated.

[aj1973]

Hi @Akshay6478 

Not sure how you are trying to make connection to SAS, but if the Dataset is in a cloud service like Azure then no need for Power BI Gateway.

[Akshay6478]

Hello @aj1973, Thanks for your reply. We are connecting to SAS datasets in powerbi desktop using OLEDB Connection. The SAS dataset is actually present in a shared drive which is accessible to all the people in our team.

[aj1973]

My Copilot gave me this answer :

Your personal and company data are protected in this chat

Certainly! Power BI does indeed support SAS data sets, allowing you to integrate and visualize your SAS data within Power BI reports. Here are a few ways to achieve this:

1. Using OLE DB:

   • You can connect to SAS from Power BI using OLE DB. Microsoft provides documentation on how to do this, which involves using the SAS Providers for OLE DB. These providers can be downloaded from the SAS Download site1.
   • To set up the connection, follow the steps outlined in the official documentation.

2. Connect Server API and OData Endpoints:

   • To import and visualize your SAS data sets in the Power BI service, consider the following steps:
     • Add a Connect Server API user.
     • Configure SAS Data Sets OData endpoints in Connect Server.
     • Create and publish a dataset from Power BI Desktop to the service2.

3. SQL Server Intermediary:

   • If you find it challenging to connect directly, consider loading your SAS tables into SQL Server (which Power BI can easily access). This approach allows you to work with SAS data in Power BI by leveraging SQL Server as an intermedia...3.

4. CData Connect Server:

   • CData Connect Server provides a pure SQL interface for SAS Data Sets, enabling you to build reports from live SAS data within Power BI. No data replication is needed, and Power BI generates SQL queries as you create visualizations