Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
alonb
Helper I
Helper I

On Premises Data Gateway

Hi guys,

 

I have an issue that I do not understand how it should work.

 

I created a new project in the Power bi desktop, the project contains two data sources
The first is database from sql server and the second is Excel file that is saved on the server.

Up to here everything is good..

The problem starts when I want to set up the On Premises Data Gateway.

The first connection with the data source of the sql server is work properly but when I try to set up the connection with the file it does not work.

Is it possible to define OPremises Data Gateway. with Excel source and DB (sql server) in the same project ? 

If so, do you have a setup guide for the Excel file ?? 

 

Best Regards,

Alon

1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion

@alonb Where did you set up the On Premises Data gateway? Your machine? The server needs to have access to the Excel file.

Alternatively, if you Excel file is in a Cloud location like SharePoint online or OneDrive, then you are trying to mix a cloud source with an on premises data source and this cannot be done with the the Enterprise Gateway yet.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

4 REPLIES 4
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @alonb,

 

Have you solved your problem?

 

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask. 

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Thanks a lot for the help, Finally I decided to manage the data from the power bi in "Enter Data" option and I removed the excel files.

Then I set up the On Premises Data Gateway from a single data source (sql server) It seems to work fine.

 

Best Regards

Alon

Hi @alonb,

 

It's glad that you have solved your problem. 

 

You could accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Seth_C_Bauer
Community Champion
Community Champion

@alonb Where did you set up the On Premises Data gateway? Your machine? The server needs to have access to the Excel file.

Alternatively, if you Excel file is in a Cloud location like SharePoint online or OneDrive, then you are trying to mix a cloud source with an on premises data source and this cannot be done with the the Enterprise Gateway yet.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.