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: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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
5,799 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,442 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,442 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,442 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,442 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,442 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,443 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,445 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,445 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,445 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,445 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,445 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,445 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,445 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,445 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,444 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,445 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,446 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,448 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,448 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,448 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors
View All