Forum Discussion
PBI and Dataset issue
Hi, Anonymous
I wonder if there are some error message in 'Refresh Histroy' in Power BI Service and the status of the gateway is online. There are three main data access scenario:
- A dataset uses data sources that reside on-premises
- A dataset uses data sources in the cloud
- A dataset uses data from both, on-premises and cloud sources
If your dataset uses a data source that Power BI can't access over a direct network connection, you must configure a gateway connection for this dataset before you can enable a refresh schedule or perform an on-demand data refresh.
You may go to 'Manage Gateway' in Power BI Serivice and add data source definition to the corresponding gateway. Also make sure your gateway admin adds your user account to the list of users with permissions to use the data source. Then The dataset settings page lets you select an enterprise gateway with a matching data source that you have permission to use. Make sure you map the correct data source definition to your data source.
Finally you can configure-scheduled-refresh or click 'Refresh now' for the corresponding dataset to refresh data.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.