Forum Discussion

Michele_Zanoni's avatar
Michele_Zanoni
Frequent Visitor
8 years ago
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 ...
Need Help
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    8 years ago
    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.
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Sounds like Direct Query is going to be your best bet. If you have Power BI Pro or Premium you can have larger imported datasets. Where does your data sit, on-premises, cloud? What is the data source, SQL?

  • Michele_Zanoni's avatar
    Michele_Zanoni
    Frequent Visitor
    8 years ago

    Hello.

     

    Thank you for your answer. The data will be on a SQL database located on an Azure service.