Automating DAX Studio...

• pietlinden

  SSC Guru

  Points: 63517

  More actions

  December 4, 2024 at 8:26 pm

  #4493356

  Still trying to figure out options for automating the export the result of a PowerQuery to SQL Server. Turns out that if I have DAX Studio installed, I can do this:

  1. Open my PBIX file that contains the PowerQuery I want to export the results from.
  2. Open DAX Studio from inside PowerBI.
  3. Go to the Advanced tab
  4. Select the table to export
  5. Specify SQL as the destination
  6. Specify Server, Schema, Authorization etc
  7. run

  Can I somehow script that and call it from maybe SSIS or something?

• December 5, 2024 at 5:47 am

  This was removed by the editor as SPAM

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  December 5, 2024 at 9:10 pm

  #4493860

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.