Forum Discussion
Quick Insights Gone?
jpquinn Quick Insights is a Service feature.
Did you miss my last post? You won't see it, it can't be used with a Live or Direct Query connection.
what considered to be a direct query?
I have a pro subscription and I created a report which its dataset is a local SQL server DB connected via Gateway.
I need to use the alerts! what should I do?
and also, it seems there isn't a way to make a scheduled refresh more often than 15 min. is there a different way?thanks.
ifat_c My last post was from 2017. Quick Insights is a feature that autogenerated visuals based on a dataset, and I'm a bit confused by your "alerts" aspect...
In any case, direct query is likely what you are using since the refresh is just the cached type. If it was import you would just see scheduled refresh.
When you connect to the SQL database, there was a toggle. You can choose direct query, which keeps your data in the database and Power BI will execute the query everytime to pull it through to the visuals. Or, you can use import and ingest the data up front and have it stored in Power BI Service. You would need to change the connection in the Power BI Desktop.
If you do go import, your schedule would be 1x every 30 minutes for up to 8 times per day. Unless you have premium which would give you 48x per day.
Alternatively there is a method to refresh using your own custom built process to run the Power BI API to refresh, that is unlimited.