Forum Discussion
Refreshing data never goes right, help?!
Hi, I have a data source (ODBC) running on one computer. It's always on and has a wired internet connection. It's connected to a database from our website. The serverconnection can only be access...
Hi ltkort,
When we add data source under gateway, we should input connection string like"dsn=sourcename". For more details, you can review the following screenshots.
1. Check your odbc source name(testodbc1 in my scenario) in Power BI Desktop.
2. Add data source under gateway by entering connection string , account and password .
3. Schedule refresh for dataset in Service.
Thanks,
Lydia Zhang
Anonymous Thank you it works!
I still have one problem.. I get the following error:
Data source errorNot a legal OleAut date.. The exception was raised by the IDataReader interface.
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity IDdf5e0578-48fd-480c-bba9-f1c084426223
Request ID25f1cd98-a41d-ce77-4e2b-a152dbbddd9b
Time2016-09-22 09:42:18Z
Is there a way to check which date field this is? I have over 45 collums with date's. And the solution you send me earlier does not work for me. I have a Date/Time stamp, if i convert this to whole number and change it back it does not change the time (it stays on 00:00:00). I tried it and it takes a long time (over 2.000.000 records).
Is there a way to check where exactly it goes wrong? Is there a log or something where this is stated? Or can I run a script that tracks this?
Is there a way to check which date field this is? I have over 45 collums with date's. And the solution you send me earlier does not work for me. I have a Date/Time stamp, if i convert this to whole number and change it back it does not change the time (it stays on 00:00:00). I tried it and it takes a long time (over 2.000.000 records).
Is there a way to check where exactly it goes wrong? Is there a log or something where this is stated? Or can I run a script that tracks this?