Forum Discussion
auto-update data from SQL Server
Hi to all,
I have realized an ETL service pulling data from Microsoft Enterprise SQL Server into Power BI.
Being both (Power BI and SQL Server) into the same machine, I would like power BI to update automatically without me to click Update button.
I tried with DirectQuery and setting a Page Refresh every 2 minutes. But after 10 min nothing happened!
Have I configurated the setting in a wrong way, or is there a better way to do this?
Thanks in advance!
G
Create a view on your SQL server that does a UNION ALL on the two tables.
Creating a union in DAX will result in a calculated table which behaves like import mode.
8 Replies
Please explain a bit more what you are trying to achieve. Are you talking about Power BI Desktop or Power BI Report Server?
I have my data in two semparated tables (Logger 1 and Logger2) within an SQL Server DB. This is connected with PowerBI Desktop through DirectQuery. For both tables the power BI Automatic Page Refreh (APR) works fine. However in order to use a slicer and other techniques (measures, calculation etc.), I need to have the data of the two tables in the same table. For this reason I have created a new table as "Union(logger1, logger2)".
My problem is that, even thogh this table is directly connected to the two tables which update automatically, this table does not update automatically at all.PS.: In order for this composite model to work, I have also activated the "DirectQuery for Power BI dataset and Analysis Services" option from settings.
