Forum Discussion
I can't load redshift data in power Bi
Hi F_senna ,
I learned that when using SQL Server as a data source, you can write SQL statements to pre-filter before importing. Other than that, there is no pre-filtering feature before importing.
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Pass parameter to SQL Queries statement using Power BI | Microsoft Learn
It‘s recommend that you try to connect the SQL Server as a data source, or try filtering in Power Query after importing.
Filter data (Power Query) - Microsoft Support
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi F_senna ,
I learned that when using SQL Server as a data source, you can write SQL statements to pre-filter before importing. Other than that, there is no pre-filtering feature before importing.
Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn
Pass parameter to SQL Queries statement using Power BI | Microsoft Learn
It‘s recommend that you try to connect the SQL Server as a data source, or try filtering in Power Query after importing.
Filter data (Power Query) - Microsoft Support
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.