Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Why eliminate the System databases

DBA's could utilize PBI more so if it allowed access to the system databases, I have stored a lot of monitoring data in the MSDB and cannot get to it unless I make views in a "user" database, not very useful.
Status: Needs Votes
Comments
jpoudou
New Member
well... as you certainly know, changing system databases is not recommended. but its done, so you have to live with it and power bi too to access your content, you can create an empty database and create views pointing to the tables stored in the msdb database.
rick_foster
New Member
Found a work around, use OLEDB and build a connection string, not as cool as point and click. While on that, why not allow search for on premise SQL Servers?
fbcideas_migusr
New Member
Status changed to: Needs Votes