Forum Discussion
Hybrid Model In PBI
Hello Anonymous,
Thank you for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank ajaybabuinturi , ThomasWeppler for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
Right now your fact table is DirectQuery and all your dimension tables are Import. Because of this mix, Power BI is trying to pull a huge amount of fact data locally to match it with the imported dimensions. When the data is very large like your 500M fact rows, this step crosses the allowed limit and you get that error, even for a simple COUNT.
If you can, try keeping your dimension tables also in DirectQuery. Then all the filtering and joining will happen directly in the database, and Power BI will only receive the final number. In that case, your COUNTROWS on the fact should work fine.
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Suppport Team.
Hey f2f
It is not a problem with DAX but with PowerQuery. Where you try to load to much data.
The best way to solve it is by limmit the amount of data you try to load into your report set, a way to do it could be to filter on time (for instant 2 years.)
You can also go from directQuery to import. This has the problem that data only will be refreshed when you refresh it and it dowsn't update automaticly.
I hope this helps. 🙂
Sorry , I didn't get you . I don't have historical data . The data will be loaded from source which is last one year of data which has 500M records in fact . we can't go with import mode with that much of data I believe .
Do we have alternate functions to achieve the count of fact table???