Yes, it is a pretty cool technique - if you work with Windows, you can do just about anything, on any version because vbScript is supported everywhere!
Definitely would like to see some more extensive vbScript working with Access. An example might be setting up a new specified directory and copying a downloaded FE and BE database into the newly created directory. Then relinking the FE to the BE Like I said before, GOOD topics for Access on this channel.
For sure, the Windows scheduler will do the best job. I found that the best way is to call the vbs script file in the scheduler using a .bat or .cmd (or powershell) file. Not always necessary, but sometimes helps. Just a single line with the name of the script in it. I'll add that to my upcoming videos!
For programming languages, I think only Python and R are supported in Power BI. M and DAX are supported for query/data transformation purposes. However, you can do a great deal of data prep in vbScript outside of PBI before the data is consumed; for example, updating a table with new figures just before PBI auto-refreshes the published version of a report.
@@seanmackenziedataengineering To tell you the truth, I use vbscript and powershell and it's not a big issue vbscript deprecation. Furthermore we can use it for years before it dissapears.
Very interesting and useful for sheduled tasks! 😉
Glad you think so!
WHAAAAAAATT!!!! I wish I had known about this sooner man that is cool Brewster !
lol! nice 👍
Sean, so this is the awesomeness you were referring to on your discord. Thank you!
Yes, it is a pretty cool technique - if you work with Windows, you can do just about anything, on any version because vbScript is supported everywhere!
This is such an excellent video , Thanks Sean
My pleasure!
Definitely would like to see some more extensive vbScript working with Access. An example might be setting up a new specified directory and copying a downloaded FE and BE database into the newly created directory. Then relinking the FE to the BE
Like I said before, GOOD topics for Access on this channel.
Thanks - I'll do some more on this topic!
Fantastic!
Many thanks!
This is great, I am interested in the scheduling part you mention. Is this the windows task scheduler or an access based scheduler?
For sure, the Windows scheduler will do the best job. I found that the best way is to call the vbs script file in the scheduler using a .bat or .cmd (or powershell) file. Not always necessary, but sometimes helps. Just a single line with the name of the script in it. I'll add that to my upcoming videos!
I wonder if VBScript can be used for Power BI?
For programming languages, I think only Python and R are supported in Power BI. M and DAX are supported for query/data transformation purposes. However, you can do a great deal of data prep in vbScript outside of PBI before the data is consumed; for example, updating a table with new figures just before PBI auto-refreshes the published version of a report.
Good stuff!!! Could vbScript be used to check for updated FE?
Absolutely! And to update it with a file from the network or FTP if necessary
Really it is cool, thanks so much.
Glad you like it!
Unfortunately vbs has been deprecated.
Thanks for sharing! What do you think about that?
@@seanmackenziedataengineering To tell you the truth, I use vbscript and powershell and it's not a big issue vbscript deprecation. Furthermore we can use it for years before it dissapears.