cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Michiel
Resolver III
Resolver III

Enterprise Data Gateway with organizational account

I have a PBI model using data from both an Oracle database and an Excel file located on a Sharepoint Online site. To refresh this, we have configured the Enterprise Data Gateway.

We now run into an issue refreshing the Excel file. When building the model we had to use 'Organizational account' to authenticate, but this authentication method is missing from the EDG configuration when adding a new data source. We get errors when trying to use other authentication methods. How can we solve this?

3 REPLIES 3
dimazaid
Microsoft
Microsoft

Hi Michiel,
Is the Excel file on SharePoint Online? You do not need an Enterprise Gateway to refresh this since it's online. You only need the Gateway if you have the file on-prem. 

DirkJ
Regular Visitor

Hi Dimazaid,

 

Michiel is helping us with our first steps in PowerBI, to make it more clear the Oracle DB is in the gateway and the sharepoint site is not.

This sharepoint site was automaticly made by making a group in powerBI here are the excel files stored.

If I put this files in power BI desktop by the WEB connection and afterwards I publish it I have to put in an authorisation I do that with OData and then refresh works (There is  only the Excel file published and refreshed)

When I put my Oracle SQL in powerBI desktop and publish (alone) is also refreshes.

But when I combine these two datasources it looks like he wants only 1 type of connection , the gateway or direct to a cloud source

Under settings dataset both gateway connection and datasource credentials are greyed out.

Like Dirk mentions, the issue lies in the combination of on-prem and cloud sources for one dataset. Power BI appears to accept only one source for a dataset, which makes sense, and it looks like we could refresh the Excel file through the gateway as well. But this is not working because of the missing 'Organizational account' option in the Enterprise gateway.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.