Forum Discussion
Helper VModel/table Information in desktop
Dear Community.
I have received one pbix file from manager.
I checked this way to find the source of the file. but its giving only name of that file, not which sheet is connected which model/table.
** Is it possible to check the model/tables source such as Model/tables has created manually or linking to any sheet.
Thanks in Adavance.
Hi NadeemAhamed
This is because the data source is an excel file.
Other details are available from the power query.or from the advanced editor :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi NadeemAhamed
You will follow the same process even if its is connect with sharepoint also.See you will see the path under source setting or advance editor
I hope I answered your question!
4 Replies
- Ritaf1983
Super User
Hi NadeemAhamed
This is because the data source is an excel file.
Other details are available from the power query.or from the advanced editor :
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
NadeemAhamedThank you for your valuable time to read and reply.
Its working only when we have connected with excel.
what about if we connect with sharepoint.
Uzi2019Community Champion
Hi NadeemAhamed
You will follow the same process even if its is connect with sharepoint also.See you will see the path under source setting or advance editor
I hope I answered your question!
- Uzi2019
Hi NadeemAhamed
You can check the source URL by going to the Power query editorThen click on the source option to check the complete URL and excel file name also.
I hope I answered your question!