Forum Discussion

gunicotra's avatar
gunicotra
Helper II
4 years ago
Solved

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 updat...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

lbendlin's avatar
lbendlin
Super User
4 years ago

Please explain a bit more what you are trying to achieve.  Are you talking about Power BI Desktop or Power BI Report Server? 

  • gunicotra's avatar
    gunicotra
    Helper II
    4 years ago

    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. 

    • gunicotra's avatar
      gunicotra
      Helper II
      4 years ago

      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. 

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        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.