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: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! 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
4,782 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
3,706 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
3,706 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
3,706 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
3,706 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
3,706 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
3,707 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
3,709 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
3,709 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
3,709 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
3,709 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
3,709 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
3,709 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
3,709 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
3,709 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
3,708 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
3,709 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
3,710 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
3,712 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
3,712 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
3,712 Views
0

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

View All
Top Solution Authors
View All