Dataset Update

[Anonymous]

Hi,

I'm trying to update a web dataet that I pull from https://www.powerbipraticacursos.com/dados/

When I uptade the URL with new data, my dataset in power BI dos not change even when I clean the credecials. Any sugestion for whats going on?

[JarroVGIT]

I assume you refreshed your dataset using the "Refresh" button? 

Have you performed any steps in the Power Query Editor that might exclude any new rows? For example, filter out any values but by doing that actually just explicit include certain items?

If you could share your M code, I could check for you if this is the case 🙂

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

I did some changes, and yes I'm using the "Refresh" button. Heres my M code:

------------------------------

let
Fonte = Web.Page(Web.Contents("https://www.powerbipraticacursos.com/dados/")),
Data2 = Fonte{2}[Data],
#"Tipo Alterado" = Table.TransformColumnTypes(Data2,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}}),
#"Linhas Principais Removidas" = Table.Skip(#"Tipo Alterado",1),
#"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"Linhas Principais Removidas", [PromoteAllScalars=true]),
#"Tipo Alterado1" = Table.TransformColumnTypes(#"Cabeçalhos Promovidos",{{"Número do Chamado", Int64.Type}, {"Empresa", type text}, {"Contato", type text}, {"Solução", type text}, {"Data Abertura", type datetime}, {"Última interação", type text}}),
#"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado1",{"Última interação"})
in
#"Colunas Removidas"

[JarroVGIT]

I don't understand, these are the same values right?:

PowerBI

Website

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

In yours it's right, but take a look in my Power Query and data:

[JarroVGIT]

And you are using anonymous access, like I am? You have many more rows, which means the website returns a lot more rows then that we are seeing when nog logged in.

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

Yes, I'm using anonymous access:

[JarroVGIT · Accepted solution]

Can you try my PBIX and see if you get the expected results? It is the table named Celoo33, ignore the other tables please they are for other questions.

https://1drv.ms/u/s!Ancq8HFZYL_aiJA8RNb7RX-OsqnWrg?e=TqahPv 

I don't know anything else that could cause this behaviour other then caching. Go to File -> Options and click on clear Cache:

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous]

You're absolutely right. Thanks a lot!