https://community.fabric.microsoft.com/t5/Power-Query/Direct-Query-and-Geographic-Fields/m-p/15646#M2467 <P>Hi,</P><P>&nbsp;</P><P>I've just set up a Direct Query to an on-prem SQL Server database, I want to make a post code field a Geographic item, is it possible to do this?</P><P>&nbsp;</P><P>With Import I did it on the Data tab but this doesn't exist for Direct Query.....</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>Mark</P> Thu, 21 Jan 2016 13:05:25 GMT Anonymous 2016-01-21T13:05:25Z https://community.fabric.microsoft.com/t5/Power-Query/Direct-Query-and-Geographic-Fields/m-p/15646#M2467 <P>Hi,</P><P>&nbsp;</P><P>I've just set up a Direct Query to an on-prem SQL Server database, I want to make a post code field a Geographic item, is it possible to do this?</P><P>&nbsp;</P><P>With Import I did it on the Data tab but this doesn't exist for Direct Query.....</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>Mark</P> Thu, 21 Jan 2016 13:05:25 GMT https://community.fabric.microsoft.com/t5/Power-Query/Direct-Query-and-Geographic-Fields/m-p/15646#M2467 Anonymous 2016-01-21T13:05:25Z https://community.fabric.microsoft.com/t5/Power-Query/Direct-Query-and-Geographic-Fields/m-p/15684#M2469 <P>Ignore me, found it!!</P><P>&nbsp;</P><P>In the field list on the report tab, click on the field, then the modelling tab appears next to the home tab at the top.</P> Thu, 21 Jan 2016 15:45:48 GMT https://community.fabric.microsoft.com/t5/Power-Query/Direct-Query-and-Geographic-Fields/m-p/15684#M2469 Anonymous 2016-01-21T15:45:48Z