This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I believe you may be running into a limitation of the Publish to Power BI API (which is used in the connector you mention). I haven't' tried, but you may be able to engineer a work-around with the Download tool to upload to a different location in Power BI. I'm not sure it'll work, but it could be worth a shot!
I hit my head against the wall for quite a while on this one and have not been able to publish to anywhere in Power BI other than "My Workspace". If anyone has any suggestions I'd love to hear them. As a work-around enabling the ability to upload to OneDrive would be a good alternative.
Thank you for recommending this enhancement. We do not have an update to the PowerBI connector scheduled at this time, but I've placed this recommendation in the backlog for the PowerBI connector and we will evaluate the capability to specify a dataset outside of My Workspace when we update the PowerBI connector.
I'm looking forward to this enhancement as well! I think it is very needed. With Power BI's recent updates (Power BI Pro, Power BI Premium, App Workspaces, etc.) it's extremely difficult to share content from "My Workspace". My goal is to update reports that are shared within my organization using Alteryx Server, but none of my reports are shared from "My Workspace", so the current connector is almost useless.
I may make a macro in the future that has an additional input for workspace and match this up with the get call, if i do i will repost it here but too busy now. Please note, this work around will only write to the Public workspace you put an id in for. you would have to repeat steps 3 and 4 for each workspace (group id) and resave the macro with a different name using this method. Macro must be stored in the same file as the original as it is using other application extensions in that folder.