CODEWITHSUNDEEP
azurereporting.net-core
Michael C
Michael C

Reputation: 231

Reporting from SQL Azure - What do I use now?

Back in the day Visual Basic came with Crystal Reports and it was (relatively) easy. Then we all moved on to SSRS and the wonders of .rdlc files. Nowadays it's all about the cloud and I've just about got over the news I can't do that any more because SQL in Azure doesn't support it. What I have not been able to find out yet is what I do instead. I need 'real-time' reporting on my live data as it is in the database. Ideally I'd like to use a nice GUI to design my reports like I always have with Crystal and with SSRS. I'd like to be able to output in PDF and Excel formats and because I'm trying to live on the bleeding edge I'm coding in .Net Core.

So my question is what I should be using now? Am I using supposed to be using PowerBI then, or is there some other option please? I've considered KendoUI and jsPDF but I'm not keen to go at it from the code side of things unless I have to.

Apologies in advance if I just haven't typed the right thing into Google to find this, I promise I did try. Thanks in advance for setting me straight!

Upvotes: 0

Views: 654

Answers (1)

Rich
Rich

Reputation: 2279

I think Power BI or Power BI Embedded would be the ticket- perhaps using DirectQuery mode so you get a live picture of the data.

If you're building a business-to-business application and you want to embed reporting in it, Microsoft would (currently) suggest you use Power BI Embedded. You could of course use one of many other reporting APIs that fit in with your application's toolset. The pricing model for Power BI Embedded is essentially per render (although it is slightly more complicated than that).

If your reporting is all internal, you could use Power BI ('Power BI Service') which comes with its own portal, or you can embed it in your appications (as long as your users have Power BI licenses).

You could still use SSRS to connect to an Azure SQL database, but you need somewhere for SSRS to run from, either on premises or as an IaaS VM in Azure.

Upvotes: 1

Related Questions