Power Query

[pedrostt8]

Estou subindo uma planilha do Excel formatada corretamente, porém o Power Query não está retornando os valores preenchidos, está retornando "null". No entanto, como é possível ver na tabela ao lado, a tabela está preenchida. Isso está acontecendo apenas com uma coluna específica. Já alterei o tipo de dados e refiz a conexão, mas o problema persiste. Alguém sabe o que pode estar acontecendo?

Desde já, agradeço pela ajuda.

[v-priyankata]

Hi @pedrostt8 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @pedrostt8 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @pedrostt8 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-priyankata · Accepted solution]

Hi @pedrostt8 
Thank you for reaching out to the Microsoft fabric community forum and a thank you to @PwerQueryKees  for the insightful guidance.

From your clarification, it sounds like the data from the second spreadsheet isn't appearing at all, even at the earliest stage of the query. This often suggests that the issue is related to how the second file is being referenced or imported into Power Query.

Here are a few things to check:

• In the Source or Navigation step, make sure the second spreadsheet is actually listed and selected and If you're working with a folder of files, ensure both spreadsheets are inside the folder and being processed.
  
  
• If the two spreadsheets contain similar tables and you want to stack the data, use Append Queries or you're joining them based on a common column, use Merge Queries Without this step, only one file’s data might be loaded.
  
  
• Check the data is inside a proper Excel table or named range Power Query may not recognize it otherwise.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.

[PwerQueryKees]

Between the screenshot from PowerQuery and the shot of your excel table, there a a number of powerquery steps. At what step is the data disappearing? And what was the opration?

[pedrostt8]

Em todas as estapas já está sem dados, são duas planilhas diferentes ai os dados da segunda planilha que não está vindo