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

Deployment query

Hi all, 

I have a doubt

  • If the data source is in cloud (like one drive or SharePoint), and the pbix created saved in locally, in this scenrio, if i will publish the Power BI report into Power BI service, will this require data gateway to be installed in local PC to enable the auto refresh. ?

Due to some constrain, i cant able to use OneDrive, so i had created .pbix using SharePoint excel data source. Now, i was bit confused, do i need gateway or not

 

Any help is appreicated 

1 ACCEPTED SOLUTION

@vijayvizzu  if you do any changes to the excel file in sharepoint online then the data will be updated you dont have to republish the pbix

OR

You can also make use of schedule refresh option in power bi service


Note:If you are using onpremise source and dont want any gateway configuration you will have to republish the file even for a small change and i wont suggest this as it take lot of manual intervention 

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍

View solution in original post

4 REPLIES 4
Memorable Member
Memorable Member

@vijayvizzu If you are saving the excel in  Onedrive or Sharepoint online then you do not need gateway configuration .It depends from where your source(excel) is coming if its onpremise like desktop then you will need gateway configuration...

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍

Thank you for the update. 

In this scnerio, if i will update the .pbix (locally saved file), will it automatically update in the power bi service or do i need to re-publish it again ?

 

@vijayvizzu  if you do any changes to the excel file in sharepoint online then the data will be updated you dont have to republish the pbix

OR

You can also make use of schedule refresh option in power bi service


Note:If you are using onpremise source and dont want any gateway configuration you will have to republish the file even for a small change and i wont suggest this as it take lot of manual intervention 

Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍

View solution in original post

you will need to republish if you are updating the pbix locally.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors