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
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

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 June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors