Forum Discussion

DouglasBrito's avatar
DouglasBrito
Icon for Helper I rankHelper I
6 years ago

Loading Power BI dataset in SQL Server

Hi there,   I need to use my Power BI (Service) dataset as data source to load data at SQL Server tables, is it possible ? Can I read PBI datasets from SSIS ?     Thanks,
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi DouglasBrito ,

If the dataset is from Premium dedicated capacity, you could reference the blog : Quick Tips: Export Power BI Desktop and Power BI Service Model Data In One Shot with DAX Studio . If you are just a pro user, maybe you could the blog which is using R might help you a little :Exporting Power BI Data to SQL Server .

Best Regards,

Xue Ding

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

DouglasBrito's avatar
DouglasBrito
Icon for Helper I rankHelper I
6 years ago

Hi Xue,

 

 

Thanks for you answer, but I am pro user and my need is to export data from a dataset from PBI service (not desktop) to SQL Server.

 

 

Thanks,

 

 

  • jessegorter's avatar
    jessegorter
    Icon for Helper I rankHelper I
    6 years ago

    I believe you can only do this when you have premium, when you can use the service as a xmla endpoint.

    But no experience with that to be honest.

     

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi DouglasBrito ,

    Sorry for late back. I took a long vacation.

     

    For using DAX studio, I think it only can be implemented for Premium dedicated capacity.  But you could use the feature of "Analyze in Excel" to export data from dataset to Excel. And then reference the blog: Creating Microsoft Excel Connections to SQL databases to load data to SQL Server.

     

    Hope this can help you.

     

    Best Regards,

    Xue Ding

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

    • DouglasBrito's avatar
      DouglasBrito
      Icon for Helper I rankHelper I
      6 years ago

      Hi Xue,

       

       

      I need it to run  from Power BI service to run on a regular basis to populate SQL DB. So DAX studio, from my knowledge, does not allow this.

       

      Thanks,

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Douglas,

        Did you get a solution to this as I am trying to do the same by querying the PBI dataset in service and export to SQL.I tried it with xmla endpoint concept,but SSIS errors out with "error in initializing provider".It seems like no .NET or OLedb providers allow this connection.Its very strange that i could connect ot other Azure AS tabular models but not the powerBI dataet in service.