Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SQL database - Refresh with latest tables

Hi all,  I am pretty begginer with PowerBi and I'm struggling with how to setup my SQL database.  -> If possible, I'd like my source to actualise with the Gateway already setup for my excel sourc...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

     

    "I can successfully connect to the SQL database, but I must then manually select the tables I'd like to import. 
    However, new tables are generated over time, and I'd like them to be integrated in the reports, thanks to the gateway. "

     

    Gateway is used to refresh the current data table to get the latest data instead of importing new tables into Power BI automatically. If you want to get the new tables, you need to connect to these tables and then publish to Service to configure gateway to refresh them.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak , Thanks for your answer. 
So that means, the report can not be automatically be updated (get values from new tables) with the Gateway ? 
I'd like to make once the measures and visuals, and then get these visuals updated with the newly created values (new tables). 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    Hi Anonymous ,

    The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

     

    "I can successfully connect to the SQL database, but I must then manually select the tables I'd like to import. 
    However, new tables are generated over time, and I'd like them to be integrated in the reports, thanks to the gateway. "

     

    Gateway is used to refresh the current data table to get the latest data instead of importing new tables into Power BI automatically. If you want to get the new tables, you need to connect to these tables and then publish to Service to configure gateway to refresh them.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.