India Data Query

[datamonkey]

We have an issue with compliance in India, which hopefully you could offer some guidance. We work in several countries and our India team would liek to use Power BI to model some of the data they've collected.

However, according to Indian law, the dat must not be stored outside the country.

So, I'm thinking a Data Gateway would make sure that the database it'self would remain on a local server of sorts, and would populate the reports when viewed.

However, I am wary that there may be come kind of cache storage of the data in the cloud somewhere, which may lie outside of India?

Any guidance you could offer would be most appreciated.

[Anonymous]

@datamonkey,

What type of database do you connect to? Data gateway is used to refresh the dataset in Power BI Service.

In your scenario, if you connect to Oracle or SQL Server database, you can use DirectQuery mode, Power BI only make a connection to the data source and data will not stored outside the country.

Regards,
Lydia

[datamonkey]

So if the Gateway is set up in DirectQuery mode, then no data would be stored in the Power BI service? Nothing cached at all?

If that's the case then that's great.

[Anonymous · Accepted solution]

@datamonkey,

When you directly connect to the database using DirectQuery in Power BI,  no data will be stored in Power BI Service and nothing cached. Power BI directly send query to your database server and request data.

Regards,
Lydia

[datamonkey]

That's great, thank you.