How to automatically run sql queires and have the results imported to Power BI for daily reporting

[BFritz90]

Hi, I run two sql queries daily, dump them into an excel file, scrub the data, then import the data into Essbase via .txt files. Can someone assist with creating a job to run the sql queries at a specified time in the morning? I would like to also have the queries automatically imported into Power BI, then data scrubed with DAX formulas. Finally, export .txt files into the Essbase shared folder for daily upload. I'm trying to figure out where to start. Not sure if I should start with SQL, Power BI, or Azure Data Studio. Any help would be greatly appreciated. Thank you! 

[NewbieYR · Accepted solution]

You can import from a database to Power BI directly, select SQL Server on Home>Data, and put the SQL query in the SQL statement.