https://community.fabric.microsoft.com/t5/Developer/Azure-SQL-embedded-not-always-connecting/m-p/49339#M1520 <P>I have a Power BI report running as an embedded application, connecting to the data on an SQL database within the Azure cloud via direct query.</P><P>&nbsp;</P><P>Sometimes this works, other times it says it accnot connect to the database (like the DB is not there). &nbsp;If I refresh the whole report sometimes it comes back, other times it does not. &nbsp;It looks like the connection to the DB is flakey.</P><P>&nbsp;</P><P>So my questions are:</P><OL><LI>Why is this happening?</LI><LI>Is this a geographical&nbsp;problem, if so where should I host my DB and Power BI collection?</LI></OL><P>&nbsp;</P><P>Thanks in advance</P> Tue, 12 Jul 2016 07:04:03 GMT DrBiker 2016-07-12T07:04:03Z https://community.fabric.microsoft.com/t5/Developer/Azure-SQL-embedded-not-always-connecting/m-p/49339#M1520 <P>I have a Power BI report running as an embedded application, connecting to the data on an SQL database within the Azure cloud via direct query.</P><P>&nbsp;</P><P>Sometimes this works, other times it says it accnot connect to the database (like the DB is not there). &nbsp;If I refresh the whole report sometimes it comes back, other times it does not. &nbsp;It looks like the connection to the DB is flakey.</P><P>&nbsp;</P><P>So my questions are:</P><OL><LI>Why is this happening?</LI><LI>Is this a geographical&nbsp;problem, if so where should I host my DB and Power BI collection?</LI></OL><P>&nbsp;</P><P>Thanks in advance</P> Tue, 12 Jul 2016 07:04:03 GMT https://community.fabric.microsoft.com/t5/Developer/Azure-SQL-embedded-not-always-connecting/m-p/49339#M1520 DrBiker 2016-07-12T07:04:03Z