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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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,488 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,219 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,219 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,219 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,219 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,219 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,220 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,222 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,222 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,222 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,222 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,222 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,222 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,222 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,222 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,221 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,222 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,223 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,225 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,225 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,225 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

View All