Forum Discussion

SiroPW's avatar
SiroPW
Icon for Helper I rankHelper I
8 years ago
Solved

Moving away from DirectQuery to scheduled refreshes (data source is a database)

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 imp...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

JordB's avatar
JordB
Regular Visitor
8 years ago

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