This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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.
Solved! Go to Solution.
The issue was unrelated to the Power BI subscription. The problem was caused by an issue in the SQL code.
The issue was unrelated to the Power BI subscription. The problem was caused by an issue in the SQL code.
Ensure the server hosting the gateway has sufficient resources and optimal performance for better refresh speed
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 22 | |
| 20 | |
| 20 |