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 ...
Need Help
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.