Get data from url with Power Query

[fjara]

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.

[fjara]

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.

[v-alq-msft]

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.

[edhans]

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.

[mahoneypat]

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]

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]

Sorry.

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

[edhans]

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]

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.