Forum Discussion

DouglasBrito's avatar
DouglasBrito
Helper 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
DouglasBrito's avatar
DouglasBrito
Helper 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.

  • DouglasBrito's avatar
    DouglasBrito
    Helper I
    6 years ago

    Hi there,

     

    You can used Get Data from Power BI dataset in Excel 2016 using a pivot table to fecth data and after a macro to create an output file as CSV. Running it as a batch command you can get a csv file without even opening the Excel file and click in a button.

     

     

    Cheers,