Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am new to BI (and to the company I am now working at), but not new to SQL Server. I'd like to start using BI to recreate many of my reports that were previously in Crystal and Excel. I've connected to my SQL Server and loaded the table I want to work with. I have a series of columns that are calculations of the existing database columns. When I add these columns to my BI file, is there any way that the data would be written back to the SQL Server database? I do not want that to happen. I apologize in advance for my "newbie" question but I don't want to mess up any of the database tables while I teach myself BI.
Solved! Go to Solution.
@ABerndt wrote:
I am new to BI (and to the company I am now working at), but not new to SQL Server. I'd like to start using BI to recreate many of my reports that were previously in Crystal and Excel. I've connected to my SQL Server and loaded the table I want to work with. I have a series of columns that are calculations of the existing database columns. When I add these columns to my BI file, is there any way that the data would be written back to the SQL Server database? I do not want that to happen. I apologize in advance for my "newbie" question but I don't want to mess up any of the database tables while I teach myself BI.
You never have to worry about "writing back" tp SQL Server. You'll find that Power BI underlying sends "SELECT" statements to your database, when monitoring from SQL Server profiler. Not yet have a completed test, for more ensurance, but I do believe that a SQL Server login(user/pwd) with read-only pression is suffient when connecting to SQL Server.
@ABerndt wrote:
I am new to BI (and to the company I am now working at), but not new to SQL Server. I'd like to start using BI to recreate many of my reports that were previously in Crystal and Excel. I've connected to my SQL Server and loaded the table I want to work with. I have a series of columns that are calculations of the existing database columns. When I add these columns to my BI file, is there any way that the data would be written back to the SQL Server database? I do not want that to happen. I apologize in advance for my "newbie" question but I don't want to mess up any of the database tables while I teach myself BI.
You never have to worry about "writing back" tp SQL Server. You'll find that Power BI underlying sends "SELECT" statements to your database, when monitoring from SQL Server profiler. Not yet have a completed test, for more ensurance, but I do believe that a SQL Server login(user/pwd) with read-only pression is suffient when connecting to SQL Server.
Thank you for the explanation! I appreciate it.
you use sql server,best way is create model in sql server analysis services tabular
You are probably better establishing Views in SQL Server and linking PBI to them - rather than tables. This way you can better manage the data volume involved both in column count and row count.
That is a very good suggestion. I will try to utilize views more. I appreciate your help.
Nope, you are fine. writing back to SQL would be awesome in some cases, but it is super not supported.... so no worries.
Thank you for the clarification. I really appreciate the fact that you took my first question posted to this forum seriously. I look forward to asking more productive questions in the future!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |