Forum Discussion

electrobrit's avatar
electrobrit
Post Patron
8 years ago

change datasource from PBI Service to OneDrive

Created a report in Power BI Service and needed to create in Desktop, but I used the dataset from the report I created in Service. Once complete, I realized I could not create an app workspace and publish in Premium workspace, it only lets me publish to the app where the dataset is in Power BI service (my personal workspace) so I'm trying to change the datasource on the pbix file to OneDrive, then I can create the app workspace and publish to it..

How can I do this without creating the report again? When I click on edit Query, it only shows Power BI service as a source. 
The goal, I need the report in Desktop (done!) and datasource in OneDrive (Help!)

thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    While in the Query editor hit "Data Source Settings"

    Then  "Change source" button in the window that pops up.

    Can browse from there to get what you need.