Forum Discussion

prabhabi's avatar
prabhabi
Regular Visitor
9 years ago
Solved

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...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

prabhabi's avatar
prabhabi
Regular Visitor
9 years ago

Hello QiuyunYu.

 

ooh great. Thanks lot for the response.

 

Regards,

Prabha

prabhabi's avatar
prabhabi
Regular Visitor
9 years ago

Hello,

 

I have a cloud powerBI pro version. I would like to connect my SQL databases with PowerBI and then generate reports, dahaboards.  Can you please provide me the step by step approach for this?

 

Note: I have created "Data gateway" and also created the datasource(connected my SQL database with basic authentication) in the PowerBI. After that, the gateway says "you are ready to go" and "test connection successful". When I try to use "Get Data" option, the powerBI shows SSAS, Azure SQL databases and etc. But it is not showing plain SQL server option. Please provide your suggestion to resolve this.

 

Regards,

Prabha