PowerBi Api with ASP.NET website

[TheracPowBi]

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.

[collinq]

Hi @TheracPowBi ,

I am not a nuget pro by any means but it appears that this article helps:

Embed Power BI report in a Power BI embedded analytics application for your organization - Power BI ...

and this one:

GitHub - microsoft/PowerBI-CSharp: Welcome to the .NET developer community for Power BI. Here you wi...

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