Power Bi & Fabric setup

Danielle Repic

I am interested in setting up an Azure database in Fabric for reporting purposes. IT has asked me to figure out what I need and how they can help. Apparently, the university has some Fabric and Power BI licenses but need to track them down. I would like to report off a database rather than SharePoint lists. (I'm a Crystal Reports user and creating a "like mdb" environment over csv files would be preferable) I have read others' posts about what they are doing (many amazing users in this group), just don't know what first steps to take. I would appreciate any advice. Thnx

Alex Wong

Azure and Fabric means 2 different things to me. So do you mean:

Azure SQL database allowing SQL database tables and SQL querying of data table

or

Fabric Data Lake where you have a "UI" interface of creating data table.

Danielle Repic

😥🤔 Well, that's a good question that I'm not sure I know how to answer. I believe a Lakehouse/Data warehouse to with a semantic model to use for reports, similar to how we can export an mbd file and then use that to report/query on. As I understand, from my limited MS training, Fabric is the overall container that combines the Lakehouse, Power BI to report from One Lake.

I have heard you speak about the SQL database that you use to report from so you're not having to use constant api calls. I may have misunderstood that point and I apologize. bbdev days put so much information into an already crowded space:)

Dennis Ladnier

Danielle, having done many of these I would suggest a basic Azure Elastic Server (this is the least expensive) and also some type of compute (i.e. vm). PowerAutomate will get you a lot of the basic's but at some point you will probably need to manage any single end-point calls (as part of a larger automation process) with a bit more flexibility. Anyway, would be glad to chat off-line should you have interest.

Dennis

Alex Wong

@Danielle Repic if you or your team have expertise with SQL already, go with Azure SQL Server. SQL is always powerful.

if there is no SQL expertise already, then you may want to invest into learning Fabric which aligns more with low/no-code methodology.

However, as Dennis pointed out, Azure SQL is much more economical than Fabric.