How to connect Network Drives as a Data source using On Premise Data Gateway (Personal) in Power BI

[Mnisar17]

Hello everyone,

I have some datasets lying in the network drives of the organization. I have created the dashboard from the datasets located in the network drives. I have downloaded the On Premise Data Gateway ( Personal Mode) and planning to refresh the datasets everyday on automation. But I get the error while refreshing that the datasets are not accessible. How can I connect my drives with the Dashboard on Power BI. I tried various option  but was not able to find some solution. Any help would be appreciated. Thank you in advance.

[v-xuxinyi-msft · Accepted solution]

Hi @Mnisar17 

With reference to the information provided by you, you are using a personal gateway.

The personal gateway can appear automatically in the gateway and cloud connections in the semantic model's setting, which requires that your service account is the same as the gateway's account, but the personal gateway is only available for import connection mode.

If you download the standard gateway, you can follow these steps:
First click on the gear button in the upper right corner and then select manage connection and gateway.

You can configure your gateway in the following settings.

Is this the result you expect?

Best Regards,

Community Support Team _Yuliax

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

[Mnisar17]

Thank you, 
I tried this way and hopefully it worked well. 

[Mnisar17]

Hello, Thank you for the feedback, but when I click on manage cloud and gatewaty connection, I'm not able to see the Add new option for the On premise gateway. 
Some features which are shown on the Microsoft learn is not what I see on my interface. 

[Martin_D]

Even though you have installed the gateway, you still need to configure the network folder as a data source for the gateway. You do this in the Power BI web app. See documentation: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

Example see here. Instead of file, you can choose folder, then path has to be a folder instead of a file: https://radacad.com/the-power-bi-gateway-all-you-need-to-know#:~:text=like%20the%20screenshot%20belo....

Related problems have already been solved in these community threads:

• https://community.fabric.microsoft.com/t5/Desktop/Connecting-to-a-local-folder-via-On-Premise-Gatewa...
• https://community.fabric.microsoft.com/t5/Power-Query/Scheduled-refresh-for-excel-file-with-on-premi...
• https://community.fabric.microsoft.com/t5/Power-Query/Data-source-for-network-drive-using-on-premise...

BR

Martin