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! Request now

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,547 Views
1 ACCEPTED SOLUTION
41 REPLIES 41
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:34 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 22 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:31 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 21 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:29 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 20 of 42
6,505 Views
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:27 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 19 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:25 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 18 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:22 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 17 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02: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 16 of 42
1,591 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:18 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 15 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:16 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 14 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:14 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 13 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:12 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 12 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:10 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 11 of 42
1,592 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:08 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 10 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:05 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 9 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02: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 8 of 42
1,594 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02: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 7 of 42
1,594 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 01:59 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 6 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 01:57 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 5 of 42
1,591 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 01:55 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 4 of 42
1,593 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 01:53 AM

@Sriku, why does the worksheet name change each 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 3 of 42
1,593 Views
0
amitchandak
Super User
Super User

‎04-06-2021 01:51 AM

@Sriku , why worksheet name is changing every time?

 

See if these can help you to use 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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 42
1,594 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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
Top Kudoed Authors
View All