cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
AntonV
Helper I
Helper I

ERROR: Invalid connection references when adding a local excel file to on-premise gateway

Hey,

 

I created a report using a SQL-db and a local excel file. When published, I wanted to schedule daily refreshes and found that I needed to install an on-premise gateway. I chose not to install the personal one, as others in my organization need to access the data as well.

 

Now I neede to add the dataset to the gateway. The SQL-db was connected in 5 seconds. But now I have trouble with the local excel file.

When I try to add the file I always get the following errror: (sorry for the dutch, I have switched my language to english but this doesn't change...)

AntonV_0-1660201924920.png

 

AntonV_1-1660201948177.png

 

Kan deze gegevensbron niet maken. Ongeldige verbindingsreferenties

Details: JDS-2022: De referenties die zijn opgegeven voor de bron File, zijn ongeldig. (Bron op c:\users\anton\downloads\jds-aanvullen.xlsx.)
Geef deze informatie door als u een ondersteuningskaart maakt.
ActivityId: da7a2915-3410-4430-9b38-c0f7817eeee9 RequestId: b1108ab6-d3dd-4d1f-a4d5-68667e9c53cb Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Aug 11 2022 09:07:37 GMT+0200 (Midden-Europese zomertijd)
 
Thanks in advance!
2 REPLIES 2
AntonV
Helper I
Helper I

Hey @gauthamboppana,

 

First thanks for the help!

But I can't find the E folder under "This PC". Sorry if I am a noob but where am I supposed to find it?

I only have a C drive it seems in Windows Explorer.

 

I have also looked to find the UNCpath of my doc but it doesn't exist it seems. Probably because it's stored on the C drive I expect?

 

Grts,

Anton 

gauthamboppana
Solution Specialist
Solution Specialist

@AntonV  - Please use the UNC / Netwrok path.  Do not use 'C' drive etc. You need to use the UNC / Netwrok path of the folder ('E' will be something like   '\\server2\Corporate\').  Go to ''This PC' > on the 'E' drive right-click > go to DFS tab. There you will find the UNC path.

Change the Data Source path in Power BI desktop and re-publish to Power BI Service.  And, now you can set up the gateway.

 



 


Hope this helps !

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors