Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Source Changing Where New Excel File Has More Columns Without Disrupting Existing Dashboards

Hi all,   I'm looking to change the data source (excel file) that is currently connected to my BI model (reports & graphs & dashboards). I created a similar excel file as the previous one but with ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    The data model will pick the new columns up. However for the dashaboard, you should add the new columns to the visual manully and republish the report the service. Then the dashboard will be updated.

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-frfei-msft,

 

Thanks for the reply. So let's say for example, I have an excel work book with x number of columns. Next I make an updated work book with multiple sheets, one of these sheets is almost identical to the original excel work book, although this sheet has more columns and data in it as compared to the original.

 

Will my data models be able to pick this up and utilize the new workbook with the updated data and as a result I get to keep my dashboards updated with my new data.

 

If so, how is this done?

 

Thanks

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

The data model will pick the new columns up. However for the dashaboard, you should add the new columns to the visual manully and republish the report the service. Then the dashboard will be updated.

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank