Forum Discussion

Vanessa250919's avatar
Vanessa250919
Helper V
5 years ago
Solved

change data source to existing report

Hello, I don't know if it's possible, I created one dataset with Oracle in PowerBI and now I want to change this data source with PowerBI Dataset it is possible ?

 

Thanks for help.

Vnaess 

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Vanessa250919 

    I do not think it is possible. Oracle connects  using a Server/DB connection and you are getting data structure from an RDBMS system. Power BI dataset is different, it Is from Analysis Services and  it has a workspace connection.

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Vanessa250919 

    I do not think it is possible. Oracle connects  using a Server/DB connection and you are getting data structure from an RDBMS system. Power BI dataset is different, it Is from Analysis Services and  it has a workspace connection.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You could just make another query starting with your new data source. Then, in the advanced editor, copy the whole source line, and then in the advanced editor of your original query, past the new source line over the current one. Note: you MUST do this in the ADVANCED EDITOR, or else your subsequent steps will be deleted!

     

    --Nate