PowerBI Report Server Schema of Underlying DB

[Chirantan]

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.

[Anonymous · Accepted solution]

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

[Chirantan]

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.