Forum Discussion
Power BI mashup in SQL
Is it even possible that Power BI can couse error in SQL 2008? My IT claims that Power BI caused mashup and destroyed the two account records
Well, in theory I suppose it is possible but incredibly unlikely. 99.999% of Power BI queries are read only and thus will not write back to a SQL table and thus destroy anything. That being said, Power BI does have the ability to execute SQL queries other than simple SELECT statements. Also it would be possible to write R code in a query that would write back to a SQL Server. So, it would be possible to execute SQL or R code that would have a negative effect on a SQL Server. Essentially this is no different than any other client that can execute SQL statements against a SQL Server.
That being said, I would be highly suspect of your IT folks and ask them what proof they have. And I'm an IT guy.
Also, causing a "mashup" on a SQL Server doesn't really sound like a real thing or at least is not common vernacular in my experience around SQL DBA's. Record or table locks perhaps, things like that but that does not sound like the proper use of the term "mashup". I have heard of "Unknown Mashup Exception" errors around SQL but I've never heard of that kind of error deleting or corrupting data.
2 Replies
Well, in theory I suppose it is possible but incredibly unlikely. 99.999% of Power BI queries are read only and thus will not write back to a SQL table and thus destroy anything. That being said, Power BI does have the ability to execute SQL queries other than simple SELECT statements. Also it would be possible to write R code in a query that would write back to a SQL Server. So, it would be possible to execute SQL or R code that would have a negative effect on a SQL Server. Essentially this is no different than any other client that can execute SQL statements against a SQL Server.
That being said, I would be highly suspect of your IT folks and ask them what proof they have. And I'm an IT guy.
Also, causing a "mashup" on a SQL Server doesn't really sound like a real thing or at least is not common vernacular in my experience around SQL DBA's. Record or table locks perhaps, things like that but that does not sound like the proper use of the term "mashup". I have heard of "Unknown Mashup Exception" errors around SQL but I've never heard of that kind of error deleting or corrupting data.
Thank you for your, I will check back with IT again. I am not also an IT person but I am the only Power BI developer in my organiozation.
