Forum Discussion
Cloud powerBI integration with SQL server database and display user interactive reports in the aspx
Hi prabhabi,
Of course, you can interactive with the report when you embed it in a application. Just like you view the report in Power BI service site.
Best Regards,
QiuyunYu
Hi prabhabi,
In your scenario, you can create a report in Power BI desktop to get data from SQL Server database. Then publish the report to Power BI service and configure data gateway for the dataset.
One way to embed the Power BI report in ASPX page is to use Publish to web feature. But please note when you use Publish to web, the report or visual you publish can be viewed by anyone on the Internet. If the report contains sensitive data, I wouldn't suggest you to do it.
Another way is follow this article: Embedding with Power BI.
If you have any question regarding embed report in a application, please post a thread in Developer forum.
Best Regards,
Qiuyun Yu
Hello Qiuyun Yu,
Thanks for the information.
Can you please provide the way for connecting PoweBI using C# code in the approach you have provided?
Regards,
Prabha
Hi prabhabi,
You can go through the article I shared in my previous post: Embedding with Power BI. For example, you click the Integrate a dashboard into an app link in this article, it will display details steps and C# code.
Best Regards,
Qiuyun YuHello Qiuyun Yu,
Thanks for the detalied steps using C# code. One more question, the dashboad/reports are user interacive in this way?
Regards,
Prabha
Hi prabhabi,
Of course, you can interactive with the report when you embed it in a application. Just like you view the report in Power BI service site.
Best Regards,
QiuyunYu