Forum Discussion
Date Refresh Timeout issue
Yeah. We want replace a lot of colunm name to another name and filter some colunm in PowerBI, we don't want it change in the SQL Sever (because some other powerbi use the same data), other than write it in advanced editor, any other ways to do this?
My advice would be to not do anything in Power Query/Query Editor other than selecting your data source.
Do all you modelling using DAX.
I've seen this issue multiple times. As soon as you add steps to Query Editor, the performance just tanks.
DAX is the way to go.
Hi is this still an issue?
We are having real problems with data refreshes failing on certain pbix files that are generally more complex in that they use the query editor to stick disparate data sources together (SQL and SSAS) using merge.
Worringly these do take the longest to refresh when it does refresh and when it fails we get messages like this below.
[DM.Pipeline.Common] Non-gateway exception encountered in activity scope: System.ServiceModel.CommunicationException: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:01:00'.
It is a very handy tool to merge data but it looks like it comes at a pretty high cost.