March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 On Premises 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
Solved! Go to Solution.
@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.
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
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
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
26 | |
15 | |
11 | |
10 |
User | Count |
---|---|
58 | |
51 | |
23 | |
14 | |
11 |