Forum Discussion

LeoCarvalho's avatar
LeoCarvalho
Frequent Visitor
9 years ago

Develop dashboard locally(Excel File Source) and then change source to Oracle Database

Hi everyone,   I'm a bit new to the PowerBI environment and am not sure how I can develop a dashboard locally with a Data Source like an Excel file and then change it's connection to an Oracle data...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi LeoCarvalho,

 

So, you means that you want get data from excel file which contains with external datasource, right?

 

If this is a case, it is possible, but you need do some additional operations. You can take a look at below link to know more about get data from excel with external datasource:

Refresh a dataset created from an Excel workbook on a local drive

 

Regards,

Xiaoxin Sheng

  • LeoCarvalho's avatar
    LeoCarvalho
    Frequent Visitor
    9 years ago

    Hello Anonymous,

     

    not really. Basically what I want is to develop a dashboard offline, on the Power BI desktop platform (with an Excel File as Data Source). Publish it, and change the connection through the Power BI service to something like an Oracle Database connection.

    Is that possible? Obviously considering that both Data Sources are identical in content and format.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi LeoCarvalho,

       

      >>Basically what I want is to develop a dashboard offline, on the Power BI desktop platform (with an Excel File as Data Source). 

      Current it not support to develop dashboard at desktop, I think you can share this to ideas.

       

      Regards,

      Xiaoxin Sheng