cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smahmood
Frequent Visitor

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 more columns in different locations as compared to the old file. Ideally I wanted to put in drop downs in the new excel file so that users can update it accordingly and then feed this information into BI.

 

I want to know how I can get BI to incorporate this new data without losing all my previous dashboards and how I can get BI to point to a specific sheet in the excel file.

 

Thanks.

Sarmad

1 ACCEPTED SOLUTION

Hi @smahmood,

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

5 REPLIES 5
v-frfei-msft
Community Support
Community Support

Hi @smahmood,

 

Based on my test, adding columns in excel will not disrupt existing dashboards. And you can refresh the datset as normal, also the new columns will be imported to the data model. If any other question, feel free to let me know.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

Hi @smahmood,

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Hi @smahmood,

 

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


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
smahmood
Frequent Visitor

Is this even possible?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.