Forum Discussion
Excel Versus SQL Database
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?
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.
1 Reply
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.