Jul 24, 20232 min readData partitioning is a technique used to divide large datasets into smallerHere's how to do data partitioning in Power BI using DirectQuery mode: Step 1: Connect to Data Source in DirectQuery Mode In Power BI...
Jul 24, 20232 min readsome key strategies to optimize the data modelsome key strategies to optimize the data model Limit Data Volume: Import only the necessary data into Power BI. Filter the data at the...
Jul 24, 20231 min readMost Important common interview Q/A in Power Bi1) how many records you pulled in the power query in the latest project? 2) Refresh the frequency time of the dataset in the power...