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 Qiuyun Yu,

 

Thanks for the detalied steps using C# code. One more question, the dashboad/reports are user interacive in this way?

 

Regards,

Prabha

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
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