Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Team ,
I have a requirement to be incorporated in Power BI .
There are 3 Millions records for one date. We tried using Direct query to create a Power BI visual , but the response time of a specific visual is 1.5 Minutes which never be accpeted. In our dimension we have Country and Measure is Simple Sum(Sales) it is a normal bar chart.
We have 150 dates in all . Please help us know if direct query is not the appropriate in such scenarios.
We also tried using import mode and the refresh takes around 14 hours to bring in all 150 dates ( This option is also ruled out)
We tried Incremental load , but eventually the PBIX file size reaches 20 GB and eventually does not open up in power BI service as we append recent data everyday.
Any suggestions will be helpful.
Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
4 | |
3 | |
2 | |
2 |