How do I run a SQL view to show all the users in each user group?

Support - Assistance technique
13

Hi @Matthew_Boddie,

I was able to save the file by pressing Ctrl+S but I can not see attributes. Here are the steps I have taken:

  1. Open the Excel file
  2. Click the Data tab
  3. In the ‘Get & Transform’ data group, clicked on the ‘Get Data’ option
  4. Go to the ‘From file’ option
  5. Click on ‘From XML’
  6. In the input data dialog box that opens up, I located the XML file that I want to import and selected it
  7. Clicked Import. the XML file is imported into power query and Navigator dialog box is opened,
    But see the data that is displayed in the preview window. . There are no display name and username as shown in the XML. it only shows user groups
    image
    image861×671 24.4 KB

    .
    8, clicking on load or transform data does not alter anything. I am unable to extract usernames

Thanks