Forum Discussion
Harpreet1405_12
Helper III
Helper IIIExcel 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 ...
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.
Greg_Deckler
Community Champion
Community ChampionHarpreet1405_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.