Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.