https://community.fabric.microsoft.com/t5/Report-Server/Link-to-an-SQL-database-via-DirectQuery/m-p/903374#M12703 <P>Hallo,</P><P>&nbsp;</P><P>when I connect my SQL Database via DirectQuery in PowerBI Desktop (My System is a Power BI Report Server) <SPAN>so I can not create a measure etc.</SPAN></P><P><SPAN>Many menu items are roughened.</SPAN></P><P><SPAN>How to fix the problem?</SPAN></P><P>Many thanks</P><P>Michael</P> Fri, 17 Jan 2020 12:03:58 GMT Brady529 2020-01-17T12:03:58Z https://community.fabric.microsoft.com/t5/Report-Server/Link-to-an-SQL-database-via-DirectQuery/m-p/903374#M12703 <P>Hallo,</P><P>&nbsp;</P><P>when I connect my SQL Database via DirectQuery in PowerBI Desktop (My System is a Power BI Report Server) <SPAN>so I can not create a measure etc.</SPAN></P><P><SPAN>Many menu items are roughened.</SPAN></P><P><SPAN>How to fix the problem?</SPAN></P><P>Many thanks</P><P>Michael</P> Fri, 17 Jan 2020 12:03:58 GMT https://community.fabric.microsoft.com/t5/Report-Server/Link-to-an-SQL-database-via-DirectQuery/m-p/903374#M12703 Brady529 2020-01-17T12:03:58Z https://community.fabric.microsoft.com/t5/Report-Server/Link-to-an-SQL-database-via-DirectQuery/m-p/904471#M12710 <P>Hey there,</P><P>&nbsp;</P><P>You should be able to create measures using the majority of the out-of-the-box SSAS functions, some of them are unavailable for direct query against a sql query.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 Jan 2020 02:21:03 GMT https://community.fabric.microsoft.com/t5/Report-Server/Link-to-an-SQL-database-via-DirectQuery/m-p/904471#M12710 mpsrshl 2020-01-20T02:21:03Z