cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted

@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
Highlighted
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!!👍

Highlighted

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 ?

 

Highlighted

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!




Highlighted

@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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors