Data Source - Big Query - DirectQuery or Import?

[Anonymous]

Hi guys, need some help for a problem. I have a report that needs to be updated everyday (20k rows) everyday. I currently paste the data to an excel sheet on my one drive and refresh it from Powerbi Service everyday, which got very tedious, hence i decided to connect it to google big query, store my data there and schedule refresh. Now i needed help with making the decision between  using directquery and import. My data is currrently at 900k rows. Should i deploy directquery because i need to it updated regularly? What about performance issues with directquery (Huge dataset)?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can refer to this document for the benefits and limitations of using direct query.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about 

You can refer to this document for data refresh in power bi:

https://docs.microsoft.com/en-us/power-bi/refresh-data 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer this video, They discuss few options that might help

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...