Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 at about 40 millions rows and 20 Gb today. The visuals we need to present to the clients involve operations of sum, distributions and so on. I'd like to understand the correct way of using Power BI:
Solved! Go to Solution.
Hello Gilbert,
thank you for the answer. I will look into Azure Analysis Server and come back with questions when they arise.
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?
Hello.
Thank you for your answer. The data will be on a SQL database located on an Azure service.