https://community.fabric.microsoft.com/t5/Developer/DirectQuery-Refresh-Rate-in-Embedded-amp-Limitations/m-p/734595#M19936 <P>I am looking to embed a PowerBI report in my application and realized that import only allows refreshes every 30 minutes. With that said, I am exploring DirectQuery (via RedShift) as my data source instead.</P><P>&nbsp;</P><P><STRONG>Will using RedShift-powered DirectQuery enable near-real-time refreshes for data in a Power BI Embedded application?</STRONG></P><P>&nbsp;</P><P>Furthermore, in the documentation for DirectQuery there was discussion around the limitations of transformations without clarifying what those limitations are. <STRONG>Is it possible to do standard SUM/AVG aggregations with DirectQuery?</STRONG> What are the notable transformation limitations that I should be concerned about before going ahead with DirectQuery?<BR /></P> Mon, 08 Jul 2019 21:35:27 GMT Anonymous 2019-07-08T21:35:27Z https://community.fabric.microsoft.com/t5/Developer/DirectQuery-Refresh-Rate-in-Embedded-amp-Limitations/m-p/734595#M19936 <P>I am looking to embed a PowerBI report in my application and realized that import only allows refreshes every 30 minutes. With that said, I am exploring DirectQuery (via RedShift) as my data source instead.</P><P>&nbsp;</P><P><STRONG>Will using RedShift-powered DirectQuery enable near-real-time refreshes for data in a Power BI Embedded application?</STRONG></P><P>&nbsp;</P><P>Furthermore, in the documentation for DirectQuery there was discussion around the limitations of transformations without clarifying what those limitations are. <STRONG>Is it possible to do standard SUM/AVG aggregations with DirectQuery?</STRONG> What are the notable transformation limitations that I should be concerned about before going ahead with DirectQuery?<BR /></P> Mon, 08 Jul 2019 21:35:27 GMT https://community.fabric.microsoft.com/t5/Developer/DirectQuery-Refresh-Rate-in-Embedded-amp-Limitations/m-p/734595#M19936 Anonymous 2019-07-08T21:35:27Z