Database doubt

[VitorXavier]

Hello,

I would like to know what happens with my PBIx if I access a database on a server and work on the Query, Pivot and View with that, then a person take out the database from the server?

[V-lianl-msft]

Hi @VitorXavier ,

You need to check which connection mode you are using.

Import - extracts the data from your database and pulls it into the Power BI Desktop

Direct Query - leaves the data in the database and sends queries to pull the information needed.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery 

If you are using direct query, pbix will not be able to connect to the data source.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi there

What will happen is if you have imported the data into your PBIX the data will stay as is.

All reports can be run, but the data will not be able to be refreshed because it cannot connect to the database server.