Forum Discussion
Error while scheduled refreshing
Hi All,
I am using postgresql db and the dataset size is in millions. We have published the report and scheduled for data refresh on all saturdays.
The automatic refresh fails all the time, throwing error as
I got a similiar thread - https://community.powerbi.com/t5/Desktop/Postgresql-Exception-while-reading-from-stream/m-p/238272#M105943
7 Replies
Hey AishwariyaV ,
where is the postgresql server? On premises or in the cloud?
If on premises did you set up the gateway properly? If in the cloud where exactly (Azure, AWS, VM)?
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biHey AishwariyaV ,
did you set up the AWS environment like it's recommended from Amazon for Power BI Service?
Check the following whitepaper from page 14 on ("Connecting the Microsoft Power BI service to
AWS data sources"):https://d1.awsstatic.com/whitepapers/using-microsoft-power-bi-with-aws.pdf
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
Hi AishwariyaV ,
As the official document said:
I would suggest you restart the gateway/service, upgrade the Powe BI Desktop to the latest version to check if the issue persists.
In addition, I also foung a similar issues have been submitted internally. Here is the ICM code——220098613. Any progress will be updated in time.
Refer to:
https://github.com/npgsql/npgsql/issues/1354
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi AishwariyaV ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed, so that more people will benefit from it.
Thanks in advance!
Best Regards,
Eyelyn Qin
