I have a Power BI file just like you have...only with some differences. I load each statement in different folders based on the name of the bank. Each folder is placed in a main folder and from THERE I load to a Excel file using only connections and do of lot of steps automatically using Power Query. Having this done....I am ensuring that all the data is clean and using the same format in each file's column👍.....by merging all together. After this is updated,...I open my Power BI file, update and boom all updated well and perfect. I have been perfecting this system and works well.
@@stevestipstechtackle Thanks for the reply. Here I don't want to fix error or don't want to know error root cause. In my pbix file we got multiple DB connections, so if one DB connection has error then rest of the DB connections and queries still should work. That is why, I want to catch DB connection error and then proceed for other connections and queries.
I removed the Music! th-cam.com/video/yGuc-N5igm0/w-d-xo.html
I have a Power BI file just like you have...only with some differences. I load each statement in different folders based on the name of the bank. Each folder is placed in a main folder and from THERE I load to a Excel file using only connections and do of lot of steps automatically using Power Query. Having this done....I am ensuring that all the data is clean and using the same format in each file's column👍.....by merging all together. After this is updated,...I open my Power BI file, update and boom all updated well and perfect. I have been perfecting this system and works well.
Nice! I have been wanting to rework mine to take advantage of data cleaning either in power BI or power pivot.
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again
Thanks, will give it a try!
That's a really good one, thanks a lot dude
why is there background music? you have a soft voice and it makes it hard to hear you
Thank you for the feedback! I agree background music really does not add much here. Will adjust. -Steve
New version without Music posted! th-cam.com/video/yGuc-N5igm0/w-d-xo.html
How to catch "DB connection Time out" error in Power Query?
Interesting... usually a timeout error means that an operation takes longer than needed. Could be the networked database is unavailable or offline.
@@stevestipstechtackle Thanks for the reply. Here I don't want to fix error or don't want to know error root cause. In my pbix file we got multiple DB connections, so if one DB connection has error then rest of the DB connections and queries still should work. That is why, I want to catch DB connection error and then proceed for other connections and queries.