Forum Discussion
In regards to Excel Data.
Indeed, I would like some clarification on this, since microsoft articles describing these features can omit details and can seem to dodge confirmation on what things can go on. Ideally I would like Excel to be connected to a database, and then that connected Excel sheet to be submitted to PowerBI, so that when the Excel sheet is populated with new information, it automatically gets added in when PowerBI's data refresh schedule takes place.
Apologies for the double post, however I am facing an issue with the Excel data source. When I submit a Excel datasheet onto PowerBI, it uploads fine; however, when I refresh after doing a quick edit in any field; that information doesn't update into PowerBI. In order to make this update, I had to open the SpreadSheet in PowerPivot on my desktop version and then update the table. Once I did this, everything worked fine and the new data was updated. Is this because Excel Online doesn't have Power Pivot, or is it my version? Also, is there a way to make it so PowerPivot automatically updates the table upon Excel's fields being modified/edited to?
Please let me know, thanks!