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.
ajaybabuinturi
thanks for the reply , I can say it was working fine when I use all fact and dimensions as direct . But I would need to check the possiblity of hybrid model as well .
Also , for my fact table native query is enabled ,means there's no problem of query folding. I request ,Is there any possibility that my COUNTROW(FACT) measure will work with hybrid model itself.
Thank you in advance.
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.
Hi Anonymous,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.Hi Anonymous,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support Team.