topic Re: PowerBI Report Server Schema of Underlying DB in Report Server

PowerBI Report Server Schema of Underlying DB

Chirantan — Thu, 26 Jul 2018 13:38:29 GMT

Hi,

Is there a document where in I can find the schema information of the PowerBI report server's db?

For instance something like the attached image which I believe is for Tableau Server's postgresql db.

Re: PowerBI Report Server Schema of Underlying DB

Anonymous — Mon, 30 Jul 2018 10:49:25 GMT

Nope! MS don't doucment the DB schema as they may change it at any time.

there are some articles out there about how to query it but you should assume these may be broken by updates (having said that I've had queiries on these guys for most of a decade and have only ever had to tweak them for new features)

I am attaching some links to some blog posts that provide some SQL queries that kind fo expose some of the undelrying structure

http://sornanara.blogspot.com/2011/05/ssrs-reportserver-database-tables.html

https://gallery.technet.microsoft.com/scriptcenter/42440a6b-c5b1-4acc-9632-d608d1c40a5c

Re: PowerBI Report Server Schema of Underlying DB

Chirantan — Wed, 01 Aug 2018 07:28:21 GMT

Thanks Stpnet!
With how new BI tools that are shaping the market and the flexibility that they offer you,I am actually surprised how MS is still holding on to things like that.
In my previous organisation to deal with partial load of data in the DW, we used a combination of SQL Server,CloverETL(integration tool),MS CLI and Tableau Server DB and Tableau Server(BI Product depoloyed in Tableau). Trying to do something on similar lines using PowerBI.