Forum Discussion
Solved
Best practices for Power BI and a large database?
Hello all, I'd like to ask for advice on deciding how to proceed with Power BI. This is our current predicament: we have a database where up to half a million records are added every day. We sit ...
- Hi there I would look to converting that if possible to Azure Analysis Services, which can compress the data.
Along with that you will be to enable Row Level Security.
As well as using DirectQuery to the Azure Analysis Services database.
GilbertQ
Super User
Super UserHi there I would look to converting that if possible to Azure Analysis Services, which can compress the data.
Along with that you will be to enable Row Level Security.
As well as using DirectQuery to the Azure Analysis Services database.
Along with that you will be to enable Row Level Security.
As well as using DirectQuery to the Azure Analysis Services database.
Hello Gilbert,
thank you for the answer. I will look into Azure Analysis Server and come back with questions when they arise.