Forum Discussion
Design advice needed
Hello, Being new to Power BI, I am not sure what the optimal design for the following problem is. Any thoughts/ideas would be appreciated. I would like to create a business user friendly data...
Since you are connecting to an Excel file, I suppose you are importing the data rather than using DirectQuery mode. How about importing the Excel data to the SQL Server database and switching to DirectQuery mode?