good quality project! can you please make a data warehousing project for the next series? Including building data model and the tables for the data warehouse. Thank you!
You will need to click refresh in your powerbi. However, if you are using the powerbi service which is the paid version, you can setup an automatic refresh. For example, you can say every day 5am refresh.
Solution to ODBC Error: Go to the security group of the Redshift cluster, click the box for the security group and edit inbound rules, Port range => 5439, source => Ipv4 Everywhere, save
thank you for your kindly, I found error in connect powerBI to redshift follow below Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired" What am I doing wrong?
There are various reasons this may have happened. I will suggest you follow what I did without jumping any steps. Let me know if you are able to fix it.
@@tuplespectra Today I tried again, I always follow steps. I try step below (same error) 1.Clear permission and get data again in PBI = Not work 2.Pause -> Resume redshift = Not work 3.Reboot redshift = Not work 4.Run airflow again + check data in redshift (normal) = Not work 5.Reinstall PBI = Not work Thank for your comment 😅
Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired" I have the same issue as @nnn56166. Also with QuickSight following all the steps
good quality project! can you please make a data warehousing project for the next series? Including building data model and the tables for the data warehouse. Thank you!
I second this thought.
Thanks for everything 💖 i have question if i add some data into csv they will automatically updated in power bi ?
You will need to click refresh in your powerbi. However, if you are using the powerbi service which is the paid version, you can setup an automatic refresh. For example, you can say every day 5am refresh.
Solution to ODBC Error:
Go to the security group of the Redshift cluster, click the box for the security group and edit inbound rules, Port range => 5439, source => Ipv4 Everywhere, save
Kindly, create a series related to data warehouse and data lake modeling and data ingrstion.
data ingestion* instead of ingrstion.
Thank you!
Explanatory!
Please sir, do you have mentorship program?
Not yet. But plan to do that in the future.
I will also be looking forward to that
Thanks @@tuplespectra
thank you for your kindly, I found error in connect powerBI to redshift follow below
Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired"
What am I doing wrong?
There are various reasons this may have happened. I will suggest you follow what I did without jumping any steps. Let me know if you are able to fix it.
@@tuplespectra Today I tried again, I always follow steps.
I try step below (same error)
1.Clear permission and get data again in PBI = Not work
2.Pause -> Resume redshift = Not work
3.Reboot redshift = Not work
4.Run airflow again + check data in redshift (normal) = Not work
5.Reinstall PBI = Not work
Thank for your comment 😅
@@nnnn56166 did you allow for public access on your Redshift?
@@tuplespectra yes I already turn on Publicly accessible
Did you able to solve the issue?
Sir do more videos
Details: "ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired"
I have the same issue as @nnn56166. Also with QuickSight following all the steps