1 - Create new BI
2 - Add a Local SQL Server datasource in DirectQuery mode
3 - Navigate to a table
(Apply changes here)
4 - Add a custom datetime column, e.g.:
= Table.AddColumn(dbo_BladeCollection_Ping, "DateTime", each #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[timestamp]))
4.1 - At this point you'll get the warning that you can't add this type of column to a Direct Query model, and you need to switch to import.
5. Close PowerQuery and Apply
Apply will fail saying "This query contains transformations that can't be used for DirectQuery". Click the button at the bottom right of the PowerBI window to "Convert to Import"
6. Groan in frustration, because now BI will tell you it can't convert, because you haven't applied your changes yet.
7. Go back to PowerQuery and remove your custom column. Close and Apply.
8. Convert to Import
Yay! It worked!
9. Go back into power query and re-add that custom column
10. Close and apply
11. Smack your forehead because you still see the error, "This query contains transformations that can't be used for DirectQuery" even though you aren't using DirectQuery anymore.
12. Try removing the custom column, re-applying, saving, closing BI, re-opening. Groan in frustration again because you still get that error message
Can you PLEASE fix this?
