Connecting to a local folder via On-Premise Gateway

[danextian]

Hi All,

I've been trying to connect to on-premise data but no luck.

Here's what I did.

>I created a report in Power BI Desktop which source is from a folder within On-Premise folder locally stored in my PC.

>Added a data source via Manage Gateways pointing to that folder

>Tested the connection and it was successful.

>Uploaded the Power BI Desktop model to the service.

>Went to the dataset settings for refresh schedule. But alas, here's what I got

You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.

Thanks for your help in advance.

[danextian]

Hi @GilbertQ and @Anonymous,

It is now working. I had to add every data source to the gateway. By the way, just a side question, can we connect to a folder/file other than that is inside the On-premises data gateway folder?

[Anonymous]

Anything that the computer/server as access too.  If you look at the Gateway screenshot i used, you'll notice i'm connecting it to a shared folder on my network (a dedicated server).

For my setup, i have a dedicated server thats hosting my on-premise data gateway.  We have a number of file share servers around the business, so i've got my gateway connecting into those where required.

[GilbertQ]

Glad it is now working.

And as @Anonymous indicated better to have a dedicated server and connect via a Shared Folder.

[danextian]

The Gateway is working fine but alas, this error: There was an error with your dataset. Select the warning icon to view the details.

I selected the warning icon but nothing happened. 😞

[GilbertQ · Accepted solution]

Go into Settings and then Datasets, and find your dataset.

Then where it says Refresh History click on that and then you should be able to view your error.

[Anonymous]

Can you screen shot the folder path as shown in the manage gateways?  I'm interested in the screen that looks like this (but your folder or file path):

[danextian]

Hi @Anonymous, please see screenshot below:

[Anonymous]

Is this the only data source in your file?  Are you also connecting to any other data sources, even if you aren't looking to refresh them?

[danextian]

Hi @Anonymous,

I forgot to mention that I have another data source that is in the same folder but instead of connecting to a folder, Power BI is accessing it directly. But I've already added that source to Manage Gateways.  The report is also connecting to a  Google spreadsheet published to the web. The link is very public and anyone can access it anonymously (the data is not confidential, just the time now). Do i still need to add that to Gateway?

[GilbertQ]

Hi @danextian

Can you please confirm how you accessed the file locally stored on your PC?

Did you access via an Excel or CSV source or via the Folders?

What you need to do is in the Query Editor, if you go into the Advanced Editor does it start with the following:

let
    Source = Folder.Files("C:\Folder Name\Data.csv"),