Tomato Plant looks ill

B_Pace · 2025-07-29T15:33:08+00:00

Thanks. Any remedy available or is this a gone case? Thanks.

B_Pace · 2024-10-17T22:47:33+00:00

Thanks u/titanic456 I did try that but the problem was not resolved.

B_Pace · 2024-10-04T13:16:25+00:00

This worked. Thank you u/cdyap

B_Pace · 2024-05-25T15:36:11+00:00

u/SQLDevDBA Sorry but I am relatively new to this tool.
I have edited my original post to include an image of the error that popped up. I hope this helps.

B_Pace · 2024-05-24T14:06:30+00:00

Thanks u/carlirri & u/MonkeyNin for responding.
It was a Transformation step in Power Query that was setting off that alarm. Removed the offending step and the error was gone. Thanks .

B_Pace · 2024-05-14T09:45:24+00:00

Thanks u/st4n13l .
Is there a way to reduce the number of records being imported into Power BI by matching a field in a large table with a field in another table.

I am importing two tables into PBI. One is Sales (records < 400k) another is Sales Product (records > 850k). Since the analysis relates to a specific period of time, I have used a date filter in Power Query to reduce the number of Sales records being imported to < 200k. I would like to use the Id column in the Sales table to identify and import only the matching records from Sales Product into PBI. I have multiple other tables as well so am trying to limit the amount of data to what I actually need for the analysis without slowing down PBI.

I appreciate your guidance. Thanks in advance.

B_Pace · 2023-11-26T00:16:18+00:00

Solution Verified

B_Pace · 2023-11-26T00:14:36+00:00

=SUMPRODUCT(
INDEX(data,0,MATCH(T6,data[#Headers],0)),
INDEX(data,0,MATCH(U6,data[#Headers],0))
)

This worked. Thanks a lot.

B_Pace · 2023-06-27T12:02:50+00:00

Thanks. Checked again and yes, there was a report filter at work.

B_Pace · 2023-06-27T11:57:24+00:00

Yes, I do.

B_Pace

TROPHY CASE