Forum Discussion
Refresh failed only online
Anonymous,
There is no fixed capacity per Pro user. That's why it is called SHARED. It depends on how much users are using Power BI Service with shared capacity.
As per my feeling usually, it is around 3-5 GB.
- Remove not used columns in data load. It means if you want to load Clients table, then prepare view/table on database side with needed fields. (Or while connecting to DB write SQL script where choose required columns).
- Reduce the number of rows in a way I told step before (smaller period or any other filters, if possible).
- Sometimes better if you will do maximum SQL JOINes on database side then on Power BI side.
Hi Anonymous,
Can you please provide more detail contents about your scenario to help us clarify your issue? (please include your data source credentials.)
Troubleshooting the On-premises data gateway
Tools for troubleshooting
Collecting logs from the gateway configurator
There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logs link near the bottom of the page, as shown in the following image.
Installer logs
%localappdata%\Temp\On-premises_data_gateway_*.log
Configuration logs
%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log
On-premises data gateway service logs
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log
Event Logs
The On-premises data gateway service event logs are present under Application and Services Logs.
Fiddler Trace
Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.
Refresh History
When using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.
-
In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.
-
In Settings for... > Schedule Refresh, select Refresh History.
For additional information about troubleshooting refresh scenarios, take a look at the Troubleshooting Refresh Scenarios article.
BTW, is there any custom functions or query parameters in your query?
Regards,
Xiaoxin Sheng
I got this message :
Connected with gateway (not personal mode) and no pb with id informations. The datas come from Dynamics NAV. And I got no pb when I refresh the report with PBI Desktop! (use 15Go/32Go of memory system)
As I said, I got no pb with the others reports (same gateway, same db...).
I don't really understand what you need to know.
HI Anonymous,
I think your issue may related to refresh data limit, please cut down your data amount and try again.
For detail information, please refer to following link:
Troubleshooting Uncompressed data limits for refresh
Uncompressed data limits for refresh
The maximum size for datasets imported into the Power BI service is 1 GB. These datasets are heavily compressed to ensure high performance. In addition, in shared capacity, the service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB. This limit accounts for the compression, and therefore is much higher than 1 GB. Datasets in Power BI Premium are not subject to this limit. If refresh in the Power BI service fails for this reason, please reduce the amount of data being imported to Power BI and try again.
Regards,
Xiaoxin Sheng