Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have fully real-time PowerBI reports in operation using DirectQuery mode and querying direct to my Amazon Redshift database.
This is great, except it can be a bit slow compared with import modes!
I'd love for a mixture of the two options.
Ideally: Users could open a report and manually hit 'refresh', refresh the data (which would then remain static) and browse around the static data as per normal import mode without having to query the DB.
Alternatively: Slow down the whole process and just do scheduled refreshes and users would be able to navigate (fast) on a slight delay.
My questions are:
For reference - I currently create the reports in PowerBI Desktop -> Publish them to PowerBI Service and then distribute them as Apps.
Thanks for your time.
Solved! Go to Solution.
Hi @SiroPW,
I think @JordB has answered your questions. One addition: it seems your scenario isn't Power BI Embedded. So users can hit "Refresh Now" if they have Edit permission.
Best Regards,
Dale
Hi @SiroPW,
I think @JordB has answered your questions. One addition: it seems your scenario isn't Power BI Embedded. So users can hit "Refresh Now" if they have Edit permission.
Best Regards,
Dale
I'm sure others will offer more detail but I'll help with what I can.
Mixed datasources was just announced at the Seattle thing.
https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-204
You could use Direct Query for elements of your report while using import for others.
Using Scheduled refresh depends on what licencing you're on, if it's standard then you can only refresh 8 times per day.
If you're Premium thing it's upto 48, so effectively every 30 mins.
Hope that helps a bit
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |