Forum Discussion
I can't load redshift data in power Bi
Hi
I'm trying to load data for redshift to power bi, but the data is a lot, so i need to limited rows before load the data in power bi.
this is the script:
let
Source = AmazonRedshift.Database("latamqa-cluster.xxxxxxxx”, "rxxxxxx”, [BatchSize=1]),
star_dwh = Source{[Name="star_dwh"]}[Data],
vw_latam_sls_bill_dtl1 = star_dwh{[Name="vw_latam_sls_bill_dtl"]}[Data]
in
vw_latam_sls_bill_dtl1
i need to limited rows of the table for load the data in Power Bi
Someone can help me?
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.
1 Reply
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.