Ollie Newth on 04 Dec 2014 03:04:34
I imagine this is going to be included within the ability to edit connections, but I would like the ability to edit an existing query or add a new one from within Power BI. Another option would be to overwrite an existing spreadsheet with one including the new queries, though conflicts might get messy.
Administrator on 05 Dec 2014 02:42:50
Hi Ollie! Thanks for the suggestion. We're already working on improvements to the management of existing connections and data sets in the service. Stay tuned for updates!
- Comments (14)
RE: Edit or add queries from the web
I'm going to pile on here - I need this as well. Beyond the need for 2-way sync mentioned by another comment here, another issue is when publishing a report to the web.
When this is done, going back to the PBIX to edit the query, then re-importing into the Web version actually creates a new report which needs new embed code and gets a new link - not ideal at all as this now involves making changes to any referencing sites/blogs/posts/etc.
It's sort of a catch 22 - make all changes in the Power BI Desktop or else you lose them if you ever need to edit the query. But doing so creates this downstream pain with Publish to Web and other features.
Bottom line: The desktop version of Power BI shouldn't have any more functionality than the web version.
RE: Edit or add queries from the web
Any news? it' been 18 months!
RE: Edit or add queries from the web
Any news on this request?
RE: Edit or add queries from the web
The aggravating part of this is if I design a report in PowerBI Desktop, then publish it to powerbi.com, edit some changes to the report online, then realize I need to edit the queries, there's no way to get the edits I made on PowerBI.com back into PowerBI Desktop. Lost work and lost time because I have to re-do those changes in PowerBI Deskop, then edit my queries, then re-publish. Would be nice if edits were synced two-way instead of up from PowerBI Desktop only.