How to push data to Power bi dataset from on-prem sql database?

Hi, Anonymous 

You can try to connect to the SqlServer database in Power BI Desktop using import mode, like this:

If your dataset needs faster data update frequency and larger data volume, you can try to use Direct query mode to connect to SqlServer database

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.