Forum Discussion
Cloud powerBI integration with SQL server database and display user interactive reports in the aspx
Dears,
We have a requirement to build a aspx page which shows the powerBI reports with user interactive. The data presented in the SQL server and our client has cloud PowerBi license. Kindly provide your input to achieve the implementation.
Thanks
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
7 Replies
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 YuHello 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 Yu
