Forum Discussion

jakesh's avatar
jakesh
Frequent Visitor
4 years ago
Solved

Automating Data Export from Power BI to Azure Data Lake or Azure SQL

Hello Everyone. 

 

I am struggling to find a solution to automate an export from Power BI to Azure Data Lake or Azure SQL. I read here about using R-Script or Python to achieve that out of Power BI Desktop but it is not clear whether this can be automated in the Power BI Service.

 

My main goal is to use an already curated data set in a Power BI report which already has all the DAX measures and logic, and then export this data to Azure Data Lake or Azure SQL so that I can then send out data extracts out of Azure to my client.

 

Thanks so much.

dataflow
General Comment
Need Help

5 Replies

  • jakesh's avatar
    jakesh
    Frequent Visitor
    4 years ago

    GilbertQ this is helpful. However, if I wanted to run the Power Automate flow without using the DAX query, what option would I use in the Power BI step to get a dataset or report to export into a CSV file to SharePoint?

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    Hi jakesh 

     

    I am not 100% sure of any other way unless you query the data directly without going via Power BI desktop.

    You could use Logic Apps, which is almost idential to Power Automate but runs inside Azure?

    • AtulsDream's avatar
      AtulsDream
      Frequent Visitor
      2 years ago

      Hello jakesh , I am also searching for, to export pdf from paginated report and store in ADLS.

       

      Can you please mention here complete flow you used to achieve this. Tried searching on the same but didnt got any document. Please help here.

       

      Thanks in Advance.