Forum Discussion
Resolver IISemantic Model never refreshed and didn't fail
Ok. Usually a mashup engine issue it's a problem at power query, but if you haven't changed anything there for a while and it worked, still a new data can break it. For example a wrong date.
I would do two things. First, copy the table of the dataflow to a power query editor in power bi desktop. Try apply and refresh there. Desktop is a better tool for communicating if there is an issue at power query. If nothing happens, second, try increasing the time outs. The sql.databases function you are probably using as source have command and connection timeout as duration. Increase it:
https://learn.microsoft.com/en-us/powerquery-m/sql-database
I hope that make sense
Resolver IIIt's difficult to tell what caused this. I don't think it's the refresh overlap or other workloads. Most don't run until later in the day. I suppose it oculd be the SQL Endpoint but I don't even know how I would resolve that. The odd part it is that's been working fine for over a year now and then today it just decided to go into this CU usage loop. I did have another instance like this where I had a report refreshing from an AWS Redshift database but the database was offline. The connection stayed open for several hours doing nothing but burning CU.
Super UserOk. Usually a mashup engine issue it's a problem at power query, but if you haven't changed anything there for a while and it worked, still a new data can break it. For example a wrong date.
I would do two things. First, copy the table of the dataflow to a power query editor in power bi desktop. Try apply and refresh there. Desktop is a better tool for communicating if there is an issue at power query. If nothing happens, second, try increasing the time outs. The sql.databases function you are probably using as source have command and connection timeout as duration. Increase it:
https://learn.microsoft.com/en-us/powerquery-m/sql-database
I hope that make sense