cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
commodity_check
Helper II
Helper II

How to connect to my files on our company network(not in sharepoint/onedrive) from Power BI service?

Hi all,

 

At our company every department has access to certain folders in our windows network (see screenshot below, for example).

I created multiple Power BI reports which use csv and Excel files which are uploaded in such folders on a daily basis. So if I hit refresh in the Pbix file everything refreshes properly.

 

But since I don't want others to be able to edit the file and want to increase user friendliness, I want to create an App workspace instead. However, I don't know how I can refresh the dataset from there. When I look for sulutions within the Power BI community, I can only find people connecting to sources in OneDrive or Sharepoint. But now that isn't the case since we use our company's network. 

 

So now I only can let people watch my reports in Power BI desktop. That works fine. How can I move to Power BI service?

 

commodity_check_0-1620054601140.png

 

1 ACCEPTED SOLUTION
_sfrost
Solution Specialist
Solution Specialist

@commodity_check 

You can abosolutely publish your PBIX file to service and use a gateway to refresh your dataset. Make sure you can access the network folder on the machine where gateway is installed. 

For more info: Solved: Scheduled refresh for excel file with on-premise g... - Microsoft Power BI Community

 

Simple way to add data source to gateway is to go to dataset seetings > expand gateway connection> under the active gateway, you should see list of sources you used in your PBIX file. Next to each source, you should see an option called add to gateway, clicking on the link will take you to gateway, filling the required details. And then you can provide username and password which has access to the network drive and save. 

Once data source is added, go back to dataset settings and confirm if the data source you just added is mapped correctly. Once done, you should be able to refresh the dataset.

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @commodity_check ,

check this post, I would recommend using one drive for business for excel file then you don't need a gateway 

 

Wish it is helpful for you!

 

Best Regards

Lucien

_sfrost
Solution Specialist
Solution Specialist

@commodity_check 

You can abosolutely publish your PBIX file to service and use a gateway to refresh your dataset. Make sure you can access the network folder on the machine where gateway is installed. 

For more info: Solved: Scheduled refresh for excel file with on-premise g... - Microsoft Power BI Community

 

Simple way to add data source to gateway is to go to dataset seetings > expand gateway connection> under the active gateway, you should see list of sources you used in your PBIX file. Next to each source, you should see an option called add to gateway, clicking on the link will take you to gateway, filling the required details. And then you can provide username and password which has access to the network drive and save. 

Once data source is added, go back to dataset settings and confirm if the data source you just added is mapped correctly. Once done, you should be able to refresh the dataset.

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps