Forum Discussion
PBI dashboard database deployement
Hello,
I work on dashbaord which is fed by a database. the database is updated every week using python scripts (scheduled running by Windows planner).
I want to publish the dahsboard in the power BI server of the company.
My problem is that I how to manage the publication and the database link:
In fact, I want to store the database in virtual machine with the update scripts.
1- should I publish the dashbaord from the same virtual machine?-
2- when the dashboard is published, the connection with database will be maintained in order to update the dashboard?
Thanks in advance 🙂
Hi Anonymous ,
1. It is recommended that it is best to publish on the same virtual machine
2. If you want to do a scheduled refresh of the report where this Dashboard is located, you need to configure a personal gateway since you are using Python as the data source.To enable scheduled refresh of your Python visuals or dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation.
Use personal gateways in Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
1. It is recommended that it is best to publish on the same virtual machine
2. If you want to do a scheduled refresh of the report where this Dashboard is located, you need to configure a personal gateway since you are using Python as the data source.To enable scheduled refresh of your Python visuals or dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the workbook and the Python installation.
Use personal gateways in Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.