Installed 64 Bit Office and Queries no longer run - PLEASE HELP

[CristianQuinone]

As the title says, was previously running 32 bit Microsoft Office Professional Plus 2016. Installed 64 bit expecting my queries to run smoother. But now I get a compatability warning on all my queries, and subsequently receive an error, pasted below. The advanced editor code is pasted below as well. I've already tried reinstalling 32 bit excel, but it did not help. 

let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
#"Sheet 1_Sheet" = Source{[Item="Sheet 1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Sheet 1_Sheet", [PromoteAllScalars=true])
in
#"Promoted Headers"

[v-pagayam-msft]

Hi @CristianQuinone ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as Accept as solution" to indicate that the question has been answered and to assist others in the community.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @CristianQuinone ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @CristianQuinone ,
Thank you for addressing the issue  @tharunkumarRTK .
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you as accept as solution. It would be greatly appreciated by others in the community who may have the same question.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!

[CristianQuinone]

Is the code I pasted below not the M code? Look down under

let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
#"Sheet 1_Sheet" = Source{[Item="Sheet 1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Sheet 1_Sheet", [PromoteAllScalars=true])
in
#"Promoted Headers"

[tharunkumarRTK]

@CristianQuinone 

Yes it is. As you can see your error message says that the issue is in "Transform file from Today" query. You did not share the M code of that query.

If I am not mistaken, #"Sample File Parameter1" that you used in your query is referring to another query called "Transform file from Today", which has an error. So, please share the m code of that query. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[CristianQuinone]

What I shared was M code for that query. Regardless, the issue has been resolved. The re-install of Excel took several nights to update to the most current version of PowerQuery. Working in a secure environment pushed the timeline for that out even further since I had to be connected to the VPN for any updates to occur when working remotely. SOLUTION: Allow Excel to update through to the most current version. 

[v-pagayam-msft]

Hi @CristianQuinone ,

We are glad the solution addressed your query. To assist others in finding the answer more efficiently, please consider marking your answer as the accept as solution.

We appreciate your valuable contribution to the community!

[tharunkumarRTK]

@CristianQuinone 

I guess issue is not with the 64 bit or 32 bit. There is a syntax error in your "Transform file from Today" query. Can you send the M code of that query?

If you look at the error message it clearly indicates that you passed two arguments to a m function which expects only one argument, so do share the m code for further assistance 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!