Forum Discussion

BenBlackswan's avatar
BenBlackswan
Helper V
2 years ago

question regarding refresh of on-prem SQL Server.

Hello,

 

This is Microsoft Tutorial on getting refresh data from on-prem SQL Server database.

 

It involves creating PBIX that import data from SQL Server, the publish to workspace, then connect the dataset (semantic model) to the SQL Server through gateway, then configure a refresh schedule. 

 

My question is, why not just create a dataflow that connect directly to the SQL Server through the gateway, and create and publish your PBIX that way?

Need Help

2 Replies

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    2 years ago

    Hi BenBlackswan ,

     

    You can go with the dataflow incase if you or your team building multiple/different reports based on the same tables.It helps to avoid data duplication and import time as you will be not importing data to individual report individually.And you will be importing data from the same dataflow to all your reports and the refresh time of your semantic model will be reduced.

    I hope I have answered your query.

     

    Thanks,

    Sai Teja 

    • BenBlackswan's avatar
      BenBlackswan
      Helper V
      2 years ago

      Hi Sai Teja, 

       

      Thank you for your replies however, I would appreciate it if you can stop reply to my questions on this forum in the future.

       

      Thank you.