Forum Discussion
Standardizing a report
Hi nattiej101
can you please explain to me how you created this Query so I can try to create it and manage it as well?
Don't get me wrong please but if you don't already have a good knowledge of Power Query this sounds unrealistic. What you can/should do:
In Excel:
- Go to Data (tab) > Queries & Connections (the corresponding pane opens on the right)
- Right-click on query CombinedYears (Power Query Editor will open
In Power Query Editor:
- In the APPLIED STEPS (on the right) click each step, one after the other to see what happens (in the middle of the screen)
PQ documentation is avail. here
I'm still getting the Null to Text error too
I built the query on the file you initially shared (‎Feb 02 2024 03:20 PM). Following my recent update the query Refreshes no problem here, with 0 error:
This means the file you currently use - as Source - has something different than the one you shared
Could you post the file with which you get Error We cannot convert the value null to type Text?
Lorenzo It's still not working.... can you please explain to me how you created this Query so I can try to create it and manage it as well?
I'm still getting the Null to Text error too:
Hi nattiej101
can you please explain to me how you created this Query so I can try to create it and manage it as well?
Don't get me wrong please but if you don't already have a good knowledge of Power Query this sounds unrealistic. What you can/should do:
In Excel:
- Go to Data (tab) > Queries & Connections (the corresponding pane opens on the right)
- Right-click on query CombinedYears (Power Query Editor will open
In Power Query Editor:
- In the APPLIED STEPS (on the right) click each step, one after the other to see what happens (in the middle of the screen)
PQ documentation is avail. here
I'm still getting the Null to Text error too
I built the query on the file you initially shared (‎Feb 02 2024 03:20 PM). Following my recent update the query Refreshes no problem here, with 0 error:
This means the file you currently use - as Source - has something different than the one you shared
Could you post the file with which you get Error We cannot convert the value null to type Text?
- I was able to fix it! I had to scrub my data a bit more - it had a hidden row. Thank you so much for all of your help.
- Glad you found the root cause yourself & Thanks for feedback
