Forum Discussion
How to push data to Power bi dataset from on-prem sql database?
Community SupportHi, 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.
- v-robertq-msft
Hi, Anonymous
I’ve read the document from your link, It involves Register an app with Azure AD and Power BI API operations, which should take plenty of time and energy. Why not just do it in the Power BI desktop and power query editor(import data and merge/append query then create relationships).
If you want to do it through rest API, you can follow this document you mentioned step by step, Thanks in advance!
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.
I resolved it by myself and you did not get my point. tks anyway.