Yiannis Antoniou on 15 Nov 2014 00:23:12
Need to be able to update dashboards with live data from Excel and other sources. This is already solved for PowerBI sites through automatic refresh using the DMG - the updated Excel file gets written to the PowerBi site, but this technique cannot be used here as there is no connection to Office 365. Either create a connection or create an equivalent mechanism for updating data (OneDrive alone is not enough).
- Comments (22)
RE: Automatic refresh of dashboards
How about a connection to the Office 365 PowerBI sites though? It seems like you are treating these as different products and I do not understand why that is the case. Are you planning to merge the environments so you do not have to rewrite every single connector and data refresh mechanism from scratch, for example, or are you abandoning the PowerBI sites product?
RE: Automatic refresh of dashboards
Power Query refresh with SQL Azure data source, please. Power BI didn't solve this problem.