After POWER BI Import done if i drop my Azure SQL Database is my Power BI report work

[Anonymous]

HI All,

i have monthely data load ,

my quesation is After POWER BI Import done if i drop my Azure SQL Database is my Power BI report work or not.

because Import create a cache in Power BI, my source data only change next month.

Regards,

Manish

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Now that the data connection is in Import mode, the laoded data is stored on Power BI side. Even if you drop Azure SQL Database, your Power BI report still works.

Regards,

Yuliana Gu

[Greg_Deckler]

Because you are using import, you should be fine. But, I would disable refresh for the data source because if you did accidentally refresh it, you would probably lose all of your data. Might not though if the connection fails completely but better safe than sorry.