Multiple Datasource and still use Direct Query

[mangchaaBI]

Hi everyone, 

Still quite new to PowerBI, we have several data sources from a SQL server for our Sales, Phone and Warehouse needs

I was able to create a PowerBI dashboard combining all tables from different sources but via Import Mode which we can only Refresh every 30 minute interval

What can be a good work around if I want the data to be updated more frequently? 

We have PowerBI Pro and Premium per User license

Thank you

[arpit2196 · Accepted solution]

Hi @mangchaaBI  ,

Please refer to the below link for a simple solution.

How to Schedule Unlimited Power BI Dataset Refreshes with a Simple Power Automate

Regards,

@arpit2196

If this post helps, then please consider Accept it as the solution and give kudos too 👍 

[mangchaaBI]

Hi @arpit2196 would you know if it's possible to just set the scheduled refresh during work hours? reason is that we dont want to stress out the database during off hours as no one is checking and just in case that anything would lock up which hopefully doesn't, then it would only happen during work hours.. thanks again

[arpit2196]

Hi @mangchaaBI ,

Please check the blog for detailed steps. 

You will be asked to provide a name, start time, and interval for your flow.Regards,

@arpit2196 

[amitchandak]

@mangchaaBI , You need to explore the Direct query model for more frequent refresh

[mangchaaBI]

Hi @amitchandak thanks for responding, is Direct Query limited to one data source only? I tried this on one of my dashboard, and as soon as I add in another source it's prompting to change to Import mode