Forum Discussion
Creating AND/OR searching
Hi,Clowson
I am very sorry to say that the suggestions I have provided do not address your needs.
According to your description, you need to display a large amount of data (55k) while satisfying the user's customized confusing query data
Due to the large size of the data, it is not possible to display it directly in visual.
You may need to use other platforms than just the power BI service to solve your problem.
Below I give advice that you can refer to.
Use power BI fabric Lakehouse or Azure SQL DataBase .etc .As the data is very large you can try to do ETL operation on the data at the data import stage.
Get the filtered data in advance and use it to build the report.
Here is the official documentation on this:
Tutorial: Microsoft Fabric for Power BI users - Power BI | Microsoft Learn
What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn
Hello,
thank you very much for the detailed information.
One problem I may have is that I am trying to build this out for unqiue 55K rows, and want the end user to be able to type the key words for search, not just to create a view.
Hi,Clowson
I am very sorry to say that the suggestions I have provided do not address your needs.
According to your description, you need to display a large amount of data (55k) while satisfying the user's customized confusing query data
Due to the large size of the data, it is not possible to display it directly in visual.
You may need to use other platforms than just the power BI service to solve your problem.
Below I give advice that you can refer to.
Use power BI fabric Lakehouse or Azure SQL DataBase .etc .As the data is very large you can try to do ETL operation on the data at the data import stage.
Get the filtered data in advance and use it to build the report.
Here is the official documentation on this:
Tutorial: Microsoft Fabric for Power BI users - Power BI | Microsoft Learn
What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn