https://community.fabric.microsoft.com/t5/Developer/Creating-DirectQuery-Dataset-using-REST-Embedded-Power-BI/m-p/194727#M6194 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/32904">@PrzemekM72</a> wrote:<BR /> <P>HI.</P> <P><STRONG>Is it possible to&nbsp; create direst query dataset using&nbsp;REST API?</STRONG></P> <P>I need to&nbsp;create new report after adding a table to DB, so I'm trying to create such dataset. No success so far.</P> <P>--</P> <P>Przemek Malak</P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/32904">@PrzemekM72</a></P> <P>AFAIK, the only way to create a dataset via REST API is following <A href="https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-walkthrough-push-data-create-dataset/" target="_self">Create a dataset in Power BI</A>. However you can update the connection string for a dataset in DQ mode by using <A href="https://msdn.microsoft.com/en-us/library/mt748181.aspx" target="_self">Set All Connections</A>.</P> <P>&nbsp;</P> <P>I'm not getting your idea "create new report after adding a table to DB", not sure why it has to be a DQ mode dataset.</P> Thu, 15 Jun 2017 09:49:39 GMT Eric_Zhang 2017-06-15T09:49:39Z https://community.fabric.microsoft.com/t5/Developer/Creating-DirectQuery-Dataset-using-REST-Embedded-Power-BI/m-p/193966#M6176 <P>HI.</P><P>Is it possible to&nbsp; create direst query dataset using&nbsp;REST API?</P><P>I need to&nbsp;create new report after adding a table to DB, so I'm trying to create such dataset. No success so far.</P><P>--</P><P>Przemek Malak</P> Wed, 14 Jun 2017 11:52:29 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-DirectQuery-Dataset-using-REST-Embedded-Power-BI/m-p/193966#M6176 PrzemekM72 2017-06-14T11:52:29Z https://community.fabric.microsoft.com/t5/Developer/Creating-DirectQuery-Dataset-using-REST-Embedded-Power-BI/m-p/194727#M6194 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/32904">@PrzemekM72</a> wrote:<BR /> <P>HI.</P> <P><STRONG>Is it possible to&nbsp; create direst query dataset using&nbsp;REST API?</STRONG></P> <P>I need to&nbsp;create new report after adding a table to DB, so I'm trying to create such dataset. No success so far.</P> <P>--</P> <P>Przemek Malak</P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/32904">@PrzemekM72</a></P> <P>AFAIK, the only way to create a dataset via REST API is following <A href="https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-walkthrough-push-data-create-dataset/" target="_self">Create a dataset in Power BI</A>. However you can update the connection string for a dataset in DQ mode by using <A href="https://msdn.microsoft.com/en-us/library/mt748181.aspx" target="_self">Set All Connections</A>.</P> <P>&nbsp;</P> <P>I'm not getting your idea "create new report after adding a table to DB", not sure why it has to be a DQ mode dataset.</P> Thu, 15 Jun 2017 09:49:39 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-DirectQuery-Dataset-using-REST-Embedded-Power-BI/m-p/194727#M6194 Eric_Zhang 2017-06-15T09:49:39Z