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

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?

Answers


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.)


I agree with the rest of the replies that involving C# might complicate your solution. That said, have you tried the rest API for PowerBI? This will allow you to push data in real-time into your reports without the refresh constraints.

https://msdn.microsoft.com/library/dn877544?f=255&MSPPError=-2147217396


Need Your Help

PHP/Angularjs/Post data empty

php angularjs

I do choose two fields (month and origin) in a form and submit it to an AngularJS controller, i am using 1.3.13 version packaged with Ionic framework.

Bounds checking of std::vector (and other containers) in clang?

clang stdvector

In clang, is there a way to enable bounds checking for [] access to std::vectors and other STL containers, preferably when building in debug mode only?