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

• We can make use of C# to push data into Power BI. For sample client app, you can refer to http://dev.powerbi.com

• Instead of pushing data into Power BI, you can better consider letting Power BI query Azure SQL Database live. It's called Direct Connect:

• You can refer here for the same: https://support.powerbi.com/knowledgebase/articles/581421-azure-sql-database-with-direct-connect