View Import From SQL Server Not Refreshing After Pro Trial Ends

[testingname]

I have been been importing a view and some small tables from SQL Server(via Azure SQL MI) for months now with no issues. The view is at around 380,000 rows with around 30,000 rows added each week. The view has 147 columns. A manual refresh in Power BI desktop was normally taking 30 seconds to 1 minute. All of a sudden, on the day that my Pro Trial expired, the view is only adding about 10 rows per second on the refresh screen(the largest table of 32,000 rows still refrehes in 2 seconds). The next day, my account was given a Premium Pro User license, but a day after that, the refresh speed hasn't improved.  It could just be a coincidence and be unrelated to the Power BI account, but I've read a few things about limitations based on the type of account a user has. Obviously, there could be an issue in the sql view, but I wanted to see first if anyone else has had this sort of issue in relation their refreshes being affected by changes in their account.

[testingname · Accepted solution]

The issue was unrelated to the Power BI subscription. The problem was caused by an issue in the SQL code.

[Ajithkumar_P_05]

Ensure the server hosting the gateway has sufficient resources and optimal performance for better refresh speed