Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

Hi All,

 

As title. Thanks in advance.

 

Regards,

Frank

Need Help

4 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.

      • v-robertq-msft's avatar
        v-robertq-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        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.