Forum Discussion
Auto refresh from excel file on Onedrive
Hi Anonymous,
We can run both the Enterprise and personal gateway on the same computer. If the dataset contains "Accounts Receivable", after publish to service, you can configure SQL Server dtaa source use personal gateway, and make sure you have entered credential under Settings->Datasets->Data source credentials for OneDrive.
Best Regards,
Qiuyun Yu
Community SupportHi Anonymous,
In your scenario, if the Excel file stored in OneDrive personal contains typed data without connecting to any external data source, when you get data from this Excel, it doesn't require personal gateway. The OneDrive refresh is enabled by default and updates files hourly.
If the Excel contains data which are retrieved from other on-promise database like SQL Server, it also can use OneDrive refresh. But to enable schedule refresh, we need to configure personal gateway like this:
To install a personal gateway and use it in gateway connection for the dataset, you can refer to this article: Power BI Gateway - Personal.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Thank you for your response. Can I run both the Enterprise gateway linked to my 10 of my datasets and the Personal gateway linked to the one dataset at the same time on my computer?
- v-qiuyu-msft
Hi Anonymous,
We can run both the Enterprise and personal gateway on the same computer. If the dataset contains "Accounts Receivable", after publish to service, you can configure SQL Server dtaa source use personal gateway, and make sure you have entered credential under Settings->Datasets->Data source credentials for OneDrive.
Best Regards,
Qiuyun Yu