Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

find dataset name

Hello, I would like to find the dataset used in a power bi report. What I do is as follows: 1- open power bi report 2- edit queries menu 3- only available option is Data source settings 4- A wi...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    Is this report live connected to Dataset in Power Bi Service?

    If so you can publish it to the service and click on View Related.

    I don't think that there is any thing in the PBI Desktop that will provide you with this info.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

In Query Editor Select any query in the Query Pane to your left and look for Advanced Editor in the Home Ribon, this will  give you the M syntax for this Query including the source of it.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I think you are referring to do doing this from the dataset window.

As mentioned earlier, in desktop report I do not get the options you mentioned i.e. query editor...

To confirm, I would like to find out which dataset the desktop report is using

Thank you

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

     

    Is this report live connected to Dataset in Power Bi Service?

    If so you can publish it to the service and click on View Related.

    I don't think that there is any thing in the PBI Desktop that will provide you with this info.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski