Forum Discussion
PowerBI Report Server Report Refresh
Caitlyn,
Thank you. Is there a difference between direct query and import? You get to both options the same way. The text you provided looks like it comes from the documentation. I guess my problem is I don't understand exactly how the data needs to be set up for the refresh to work.
Thanks
Lynne
Hi lmoranian ,
Import Connection – Import Data Connectivity mode lets you import data into Power BI cache. Highly recommended to use Import connection when the data size is less than 1 GB and the data is not continually changing. You can import data with schedule refresh to get the latest data. With Import connection, you can take full advantages of the high-performance query engine.
DirectQuery – DirectQuery Connectivity mode lets you connect directly to data. DirectQuery mode used to build Real-time or near real-time BI solutions when the data is changing frequently, and Data volume is very large. No data will be imported into Power BI. Instead Power BI will send queries to the data source upon building visual/interacting with visuals. Each query is restricted to return less than or equal to 1 Million rows.
For more information，you may refer to ：
Power BI Tips: Import vs Direct Query
Dataset modes in the Power BI service
About using DirectQuery in Power BI
Best Regards,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.