Skip to main content

    Power BI

    New

    Powerbi should have a feature (interface) to export dataset to sql server table, map columns, select datatypes etc & add that as a step

    Vote (1) Share
    Apoorv Dubey's profile image

    Apoorv Dubey on 23 Sep 2021 07:22:34

    Currently the only way to export Powerbi Dataset (created through query) to SQL server table is by using R or Python & its full of issues & uncertanities. Easiest way would be to use somekind of Powerbi wizard using which we can select sql server table(create new) & map columns with dataset & once its mapped & uploaded to SQL table should be able to add that step in a query. This would make life a lot easier.