Switch from load data to direct query

Updating Queries to use DirectQuery (Wildly unsupported and a very Bad Idea™)  I stuck this in a post that's a little easier to read. But I'm leaving it here for when my blog inevitably dies along with me.  http://blog.teknikcs.ca/2017/03/25/converting-powerbi-desktop-reports-from-import-to-directquery/ Updating Queries 1. Attach a debugger to the PowerBI desktop application.  2. Replace all instances of the following bytes:  44 69 72 65 63 74 51 75 65 72 79 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 14  with 44 69 72 65 63 74 51 75 65 72 79 01 00 00 00 00 00 00 00 01 00 00 00 00 00 00 00 14 Updating Relationships: There's two ways of going about this: 1. Be smart and write a little asm patch that replaces any calls to read the memory location to read back from your own location.  2. Be lazy like me and let pbi desktop reinsert the overwritten IgnoreCase setting (reason being that you can't just 'add space' to the memory of a loaded application for our new tag).  Since I am inherently lazy this is the second way. Search the memory for the string below and replace it with the one after INCLUDING WHITESPACE (probably best to just edit in memory, whitespace out the rest of the unreplaced IgnoreCase option (hex 20))  PreferOrdinalStringEquality="true">  PreferOrdinalStringEquality="true" DirectQueryMode="DirectQuery" /> Now after saving and reloading (on a copy of the report obviously) PBI should ask to revalidate the queries and you'll need to remove unsupported functions like calculate and datetime stuff. I personally lost my computed columns and measures but everything else worked. If you search memory again PBI should have reinserted the IgnoreCase option in the relationships after the direct query option. If it didn't.... well.... like I said. Bad Idea!