Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Sriku
Helper IV
Helper IV

Error in refresh Powerbi due to worksheet name change

‎04-06-2021 01:12 AM

Hi All, I need a suggestion, I am getting error while refreshing the dashboard due to chnages in worksheet name for every refresh.

I manually go and change the sheet name and refresh the dashboard. Is there any way once it loaded it will automatically refresh without changing the sheet name.

 

Please suggest

 

Regards,

Sriku

Labels:
Message 1 of 42
6,136 Views
1 ACCEPTED SOLUTION
41 REPLIES 41
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:26 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 42 of 42
4,633 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:23 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 41 of 42
4,633 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:20 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 40 of 42
4,633 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:17 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 39 of 42
4,633 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:15 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 38 of 42
4,633 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:12 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 37 of 42
4,634 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:09 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 36 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:06 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 35 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:03 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 34 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:01 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 33 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:58 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 32 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:55 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 31 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:52 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 30 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:50 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 29 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:47 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 28 of 42
4,635 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:45 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 27 of 42
4,636 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:43 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 26 of 42
4,637 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:40 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 25 of 42
4,639 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:38 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the leaf index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 24 of 42
4,639 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:36 AM

@Sriku, why do you change the worksheet name every time?

See if this can help you use the sheet index

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

https://community.powerbi.com/t5/Power-Query/Importing-dynamic-named-worksheets/td-p/236254

Message 23 of 42
4,639 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All