Forum Discussion

fjara's avatar
fjara
Helper I
5 years ago

Get data from url with Power Query

Hello.

I can get data and I can edit this. But I cannot aplly the data into the data model.

The next print show the data in Power Query .

 

 

The next print show the data when I apply the data to the data model.

There are no data in the table.

 

Can you help me!

Thanks.

 

 

 

Need Help

8 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago
    1. Are there any errors when it says it is loading?
    2. Can you go to the report view then back to the data view and click on the table? I've seen the table show empty before and you just had to refresh the view
    3. Can you give any other details on what you are doing, or any messages?
    • fjara's avatar
      fjara
      Helper I
      5 years ago

      Hello Edhans,

      1. No errors when loading.

      2. When I back to Power Query editor and refresh, the table is empty, like you can see y the next screen.

       

       3. I can show you the table in the navigator.

      Thanks.

       

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    I've seen this behavior before and can't explain it.  When you pull down one of the column filters, do you see data values there (the arrow at the top of each column)?  When I see this, if I filter on something, the filtered table shows up.

     

    Also, you should promote your first row to become the headers.

     

    Regards,

    Pat

    • fjara's avatar
      fjara
      Helper I
      5 years ago

      Yes, I can see values.

      I have selected "Desborde SUBE NSSA" in column1.

       

       

       

       

      Then I promote te columns names and select a different value in column "CAMPAÑA" ("Piloto SUBE").

      I can see all values.

       

      A question: The url is not "https". Is this relevant?

       

       

       

      • fjara's avatar
        fjara
        Helper I
        5 years ago

        Sorry.

        Now, I refresh previous view and send the follwing msg.

         

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    I think that is saying there is no column with that name to filter, so perhaps you renamed in an earlier step but didn't redo the filter subsequntly applies. I cannot be sure, and I cannot paste that error into a translator.

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, fjara 

     

    Based on your description, there is no data in Power Query after the refresh. I wonder if you have made some changes in earlier steps like filtering rows. You may try creating a new query and apply the same transformations to the data source to see if it works.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • fjara's avatar
    fjara
    Helper I
    5 years ago

    Hi Allan!

    I am very grateful for your help, but I have not more time.

    I am attemping get the data by another way.

    Thank.

    Fernando.