Forum Discussion
Too slow with DirectQuery, too big to import
Anonymous
I've solved my problem
If someone encounter the same problem here what I did :
First I've created a view of my big table, with only the needed columns.
As my datas are dated from 1994 to today, I have 2 view : one for datas before 2014 and for datas since 2014 (They don't really need very old datas in my company)
Then i've tried to DirectQuery but it was still very slow.
I've disabled the options of type detection / relations in the Loading Data part
Then I've imported it and it worked perfectly fine, it's very fast (1 or 2 seconds of loading with millions of rows)
quentin_vigne,
Please go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing" in Power BI Desktop, then load data into your graph and check the detailed logs in the traces folder. Also please help to post the detailed logs here.
Regards,
Lydia
Anonymous
I've solved my problem
If someone encounter the same problem here what I did :
First I've created a view of my big table, with only the needed columns.
As my datas are dated from 1994 to today, I have 2 view : one for datas before 2014 and for datas since 2014 (They don't really need very old datas in my company)
Then i've tried to DirectQuery but it was still very slow.
I've disabled the options of type detection / relations in the Loading Data part
Then I've imported it and it worked perfectly fine, it's very fast (1 or 2 seconds of loading with millions of rows)
Friend, good morning and tell me when publishing your data to the service of power bi, do not have problems with the time of publication? or what is the time it takes
It takes between 5 and 10 minutes to publish to Power BI service (my file weight 300 - 400Mo) and I keep them updated with the Power BI gateway. When scheduled the reports takes 10-20 minutes to refresh at the same time (I have 4 reports)
- Quentin
- I have a 200 MB bi power file (BD SQL connection - IMPORT) and one hour and media in power bi services that are somewhat 2 million records What recommendations would you give me for this publication process to be streamlined? The database that I connect is remote and is within the network. and another consultation with the power BI gateway is the update faster?
