Publishing in PowerBI

[cmboudreaux]

So the basic structure I have for a PowerBI is an excel spreadsheet, a PowerBI table, and then the workspace it is published to. I want to be able to change the info on the spreadsheet then hit refresh and publish and have the webpage content updated. The issue I have is the embedded url keeps changing making it cumbersome to update things without a bunch of extra clicks. Whats the easiest way to publish and have things sync up?

[cmboudreaux]

allow me to elaborate more - cause currently just hitting refresh of the dataset isnt working. There is a source file that is stored on a workstation locally. the user updates that excel spreadsheet and those changes dont seem to commit until the refresh is done in PowerBI Desktop. then those changes dont seem to go over until the user hits publish to the workspace. Perhaps the detail I was missing is that everything was developed in powerbi desktop and then published to a workspace within O365

Should i change where the source excel file is located and then in turn host the pbix file within sharepoint or something?

[JorgePinho]

You don't have to refresh and publish on Power BI Desktop every time you change the spreedsheet.

When it is published you just need to refresh the dataset on Power BI Service like this: