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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors