Changing the name of excel file in sharepoint/ Microsoft Teams

[Anonymous]

Hi,

When I change the name of source file in Microsoft teams as we can open file from teams in sharepoint and that is from where I uploaded the file and then I opened Advanced query editor in query editor window and changed the name of the file there. It still gave me an error and the file's new name was not identified. Why Is It like that?

Thanks in advance

Best Regards,

Diksha Gupta

[Anonymous]

Hi @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Otherwise, please provide the required information. Thank you. 

Best Regards

[Anonymous]

Hi @Anonymous ,

Please review the content in the following link and check whether you face the same situation with it:

Expression.Error: There weren't enough elements in the enumeration to complete the operation

Power Query - Changing Source

In addition, could you please provide the applied codes in Advanced Editor and some screenshots when get the error message in order to make troubleshooting? What's the old file name? Thank you.

Best Regards

[Anonymous]

Hi,

Thank you for replying. 

This is the link of PBIX File.

I've changed the name of file from Price Comparison to Price Comparison1. Could you please explain how can I correct this error shown in the PBIX File?

[Anonymous]

Can you pls tell me Hwo Can I share PBIX File here ? I'm unable to do so. 

[Anonymous]

Hi @Anonymous ,

You can refer the method in the following thread to upload the file and share the file link with us. Thank you.

How to upload PBI in the community

Best Regards

[Anonymous]

https://drive.google.com/file/d/1Ld_m97ynE69WCKGx5iEwVKRUjY73cT41/view?usp=sharing

This is the link, I hope It works for you.

Thank you very much.

Best Regards,

Diksha Gupta

[Anonymous]

Hi @Anonymous ,

I can't access to your shared file, could you please try to share the file by another method? Thank you.

Best Regards

[Anonymous]

I have given you the editing rights. Can you pls now click on it and check?

Thank you

[Anonymous]

Hi @Anonymous ,

Thanks for granting me the access to your report file. As checked your report file, it seems that you were trying to access the excel file under the following 3 folder paths. Could you please check whether there exist the file named with "Price Comparison.xlsx"? Whether the name of this excel file has been changed to other one?

https://grpleg.sharepoint.com/sites/GIAinternship/Documents partages/Digital projects/Controls automation/

https://grpleg.sharepoint.com/sites/GIAinternship/Documents partages/Digital projects/Controls automation/Payables/

https://grpleg.sharepoint.com/sites/GIAinternship/Documents partages/Digital projects/Controls automation/Payables/Romania test/

Best Regards

[Anonymous]

Yes exactly. I've renamed the file as price Comparison, now how Can I change the name here in PBIS for It to work?

Thank you.

Regards,

Diksha

[Anonymous]

Hi @Anonymous ,

As checked the applied codes for the query "Sample File" in Advanced Editor, the name of the related excel file has already be "Price Comparison". So it seems that the file name is OK. Could you please provide the related screenshots for the files under those 3 folder path(refer in my previous post)? I need to check whether the file "Price Comparison" exist there. By the way, did you get the error message when run it in Power BI Desktop?

In addition, you can try the method in the following blog to update/remove the data source setting and check whether it can work.

Edit Or Remove Permission From Existing Data Source Connection From Power BI

Best Regards

[amitchandak]

@Anonymous , was the previous excel that has taken from SharePoint having a table, means you have taken a table that is not present in the new sheet (excel table) ?

The best is to create a new connection and take the top part from the new connection and replace it in the old file