Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I am working on creating the POWER BI Reports where currently I am fetching the data from an Excel spreadsheet (which has multiple tables) If someone wants to add a new page or tab then I have to make the changes at the spreadsheet first and then rearrange in the Power BI Desktop.
Is there a better way to do that?
Shall I use the SQL server and save all the data there?
Solved! Go to Solution.
@Harpreet1405_12 Not sure if moving to SQL will solve the core of your problem. If someone wants to add a new table, you'd still have to add the table in SQL server and still have to go into Power BI Desktop and create the query for it. So...
But, yes, in general, SQL is a better data store than Excel. It is structured vs. unstructured and should perform faster, etc.
@Harpreet1405_12 Not sure if moving to SQL will solve the core of your problem. If someone wants to add a new table, you'd still have to add the table in SQL server and still have to go into Power BI Desktop and create the query for it. So...
But, yes, in general, SQL is a better data store than Excel. It is structured vs. unstructured and should perform faster, etc.