Model/table Information in desktop

[NadeemAhamed]

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. 

[Ritaf1983 · Accepted solution]

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

[Uzi2019]

Hi @NadeemAhamed 

You can check the source URL by going to the Power query editor

Then click on the source option to check the complete URL and excel file name also.

I hope I answered your question!

[Ritaf1983 · Accepted solution]

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

[NadeemAhamed]

@Uzi2019 

Thank 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. 

[Uzi2019 · Accepted solution]

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!