Is it possible to push data into Microsoft PowerBI from Azure SQL Database using C#

Question

I'm working on creating a dashboard with 2 other colleagues. One of the colleagues has uploaded the data into Azure SQL Database. Essentially, I would like to use C# as a programming language and connect to the server and push the data into Power BI. Can this be achieved?

Answer 1

Certainly you can use C# to push data into Power BI. See the client app sample at http://dev.powerbi.com

But my suggestion is rather than you pushing data into Power BI, consider letting Power BI query Azure SQL Database live. It's called Direct Connect: https://support.powerbi.com/knowledgebase/articles/581421-azure-sql-database-with-direct-connect

(Thorarins posted this link above first in fairness.)