Forum Discussion
PowerBi Api with ASP.NET website
Hello everybody.
This is my situation. I have an ASP.NET solution that lauch a website.
On my website, I have embedded a PowerBi report. To do that, I connected PowerBi with a database by using the import method in PowerBi desktop.
But, in my final solution I don't want to do that.
I can access directly to my database with my ASP.NET solution, with a project named DAL.
So, what I want to do is to use the PowerBi nuget package to be able to use the data that I have from my DAL project, and then build a report (or just embedded it on my website) by using the dashboard configuration that I already have on PowerBi.
So, to be more clear :
I DON'T want that PowerBi to be connected to my database, but only integrated, via the Powerbi nuget package, to my ASP.NET solution.
I already have my ASP.NET solution connected to my database, and I want to be able to past this data to PowerBI, by using the PowerBi nuget package.
Is this possible, or is it necessary to give access to the database to Powerbi in order to embedded it ?
Thanks for your time and your answers.
1 Reply
- collinq
Super User
Hi TheracPowBi ,
I am not a nuget pro by any means but it appears that this article helps:
and this one:
In thinking about the larger topic about that you don't want Power BI to be connected to the database, I am wondering if that is feasible. Power BI has to read the data from somewhere - from a location. Whether it gets the data from a dataflow, a different dataset or streaming data it has to connect to something. So, if the nuget package can serve up the data in a format that Power BI can read.
Based on this article, from last month, it shows that you can use an API so in that case Power BI is not actually hitting the database - the API is.... Announcing Power BI APIs .NET SDK v4 | Microsoft Power BI Blog | Microsoft Power BI
