User Profile
CC_C
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Prevent Power Query from trying to convert string to number?
I have an Excel workbook with several sheets that each contain a table. Different users are meant to make edits on their respective tabs. I have a query that appends each of these tables into a master table. This is working well, except for an error that I can't figure out: The "Notes" column holds notes (strings). The record shown above is the only one generating an error. As you can see "Contract is Complete" is clearly text, and the column is formatted as text in the query. It's formatted as text in the source table also. I cannot figure out why Power Query is trying to convert this one particular string to a Number format. Thanks for any advice!Re: Is there any way to prevent the model from refreshing every time I create a measure?
Thanks for the response. This sounds like a promising way to avoid the constant recalculations, unfortunately I don't expect my company will pay for a license. Can I ask your opinion on the DirectQuery workaround I mentioned? "Copying" every table feels sloppy and wrong, and of course performance is affected, but I can't find another way to add calculated columns to these tables.Is there any way to prevent the model from refreshing every time I create a measure?
I'm working in a file that uses a DirectQuery dataset containing several tables. I need to add calculated columns, which is a limitation of DirectQuery, so my current solution is to "clone" those tables with a calculated table and work with those. This works, but every time I create or edit a measure the model is recalculated, and due to the size of the data sources this is creating a huge lag (like 30 secs) before I can write any DAX. My project requires quite a few measures, so this obviously is making development extremely time consuming. Is there anything I can do to avoid these constant recalculations? Since I'm using DirectQuery I am not able to make any changes in the query editor, which is an approach I've seen suggested elsewhere.
