Forum Discussion
On Premise Data Gateway - Single database, different username
vranjan22 In Power BI the user account that created the gateway will have access to the gateway there. You can add other admins if necessary, but you will create a datasource on the gateway using the credentials specific to the SQL DB. Then you can apply users to the datasource who have access to use it when publishing reports.
Thank you Anonymous for your response.
I am quite new to Power BI & Power Apps, hence I may not understand all the suggestions shared by you.
The datatable and the on-premise gateway are configured on a server. The datatable is getting updated using PowerApps which is connected through the on-premise gateway. The ID used for PowerApps & gateway is same.
Now, I am creating a PowerBI report for the datatable. I have used PowerBI desktop for connecting to SQL datatable & designing the report. While publishing, I am using a different account. At present, in order to refresh the PowerBI report, I doing following steps:
Open report in PBI desktop > Refresh data table > Save & Publish the report
I am looking for skipping the steps above. The PowerBI reports should automatically get refresh at regular intervals.
Please advise.
Thanks,
Vivek