Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
I am building a report that requires live connection to db and get it refreshed every min. What is the best route to start the report Direct Query or Import ? The report requires some Time Intellegince based calcuation which is limted in Direct Query method I think and it needs constant refreshing which is limted in Import route to only 8 times a day. So I am in pickle situtation ?
any help would be very much appreciated.
thanks
Anbu
Hi @CharityBI,
Have you resolved your issue? If you have, please mark the right/helpful reply as answer. More people will learn new things here.
Thanks,
Angelia
Hi @CharityBI,
Both import and Direct Query can not refresh very min, which is a limitation up to now. Please review this idea. You'd better use a import model, so that you can all Time Intelligence function.
For one option, you can purchase Power BI Premium, there is no refresh frequency limitation for premium account.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.