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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
spencer_II
Helper I
Helper I

Data Flows-getting past connection settings

No matter the source / Excel or Blank Query I cannot get past the connection settings.

Exhausted forums and youtube on subject.

 

sshot-965.png

Thank you,

 

SMG

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi @spencer_II 

Based on my research, your File path or URL is wrong.

it should like this format:

C:\Users\linli\Desktop\xxx\xxxx\xxxx\New Microsoft Excel Worksheet.xlsx

3.JPG

 

Not your path  C:\Work\Analysis\Pwr BI Monthly

 

By the way, for local file, you need to add a new datasource in manage gateway like below:

4.JPG

And when you add this datasource, please don't enable Skip Test Connnection that make sure you could have a test this datasource.

 

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

 

Regards,

Lin

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

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi @spencer_II 

Based on my research, your File path or URL is wrong.

it should like this format:

C:\Users\linli\Desktop\xxx\xxxx\xxxx\New Microsoft Excel Worksheet.xlsx

3.JPG

 

Not your path  C:\Work\Analysis\Pwr BI Monthly

 

By the way, for local file, you need to add a new datasource in manage gateway like below:

4.JPG

And when you add this datasource, please don't enable Skip Test Connnection that make sure you could have a test this datasource.

 

https://radacad.com/the-power-bi-gateway-all-you-need-to-know

 

Regards,

Lin

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

I don’t think you can set it to a local file. 
It either has to be a network location or a (Sharepoint) URL. 
Next to that you also should be a user of the data gateway entry for this location. 



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


Thank you... so if I saved the file containing the Power Query to OneDrive?

 

Appreciate the assistance.

 

Spencer🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors