cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruliana
Helper I
Helper I

Using DirectQuery to access a file in a network drive

Hi,

 

I am trying to use DirectQuery to connect to Excel files that are saved onto a network drive. We have been just importing this data into PBI using the Excel option but we are trying to automatically refresh our reports while avoiding Gateways to setup auto-refreshes of the data and wanted to test using DirectQuery. Which option under "Get Data" should I be using to be able to directly link to the sheets.

 

Here's an example of my file path:

\\aaa.companyname.com\home\ops\pltraining\matt's folder\section meetings\plant A\plant A utilization.xlsx

and I have files in several other folder locations branching from the Section Meetings folder if that makes a difference.

 

 

Thanks!

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @ruliana ,

 

We can use the web Connector (Web.Contens function) to get the online excel and then we can convert it into a excel file. In most cases,  using Web Connector in Import mode can configure scheduled refresh without using gateway. But we cannot using Direct Query with Web Connector based on this document.


Best regards,

 

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

I don't believe Direct Query will work for this.  Direct Query is intended for connections to databases, will pass a query into the database as users manipulate visualizations.  You're going to want to use Import.

See this link.  Quote: "DirectQuery is only feasible when the underlying data source can provide interactive queries (less than 5 seconds) for the typical aggregate query, and is able to handle the query load that will be generated."


Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!