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

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors