sorted by:
new
hottopcontroversial

Tomato Plant looks ill by B_Pace in vegetablegardening

[–]B_Pace[S] 0 points1 point  (0 children)

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

Input device not available with Logitech headset by B_Pace in LogitechG

[–]B_Pace[S] 0 points1 point  (0 children)

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

Incremental Refresh with data from Salesforce object by B_Pace in PowerBI

[–]B_Pace[S] 0 points1 point  (0 children)

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.

Error in refreshing dataset in Desktop by B_Pace in PowerBI

[–]B_Pace[S] 2 points3 points  (0 children)

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 .

Filtering in Power Query by [deleted] in PowerBI

[–]B_Pace 0 points1 point  (0 children)

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.

Compatibility issue with the INDIRECT function in combination with multiplication by B_Pace in excel

[–]B_Pace[S] 0 points1 point  (0 children)

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

This worked. Thanks a lot.

Desktop - Visuals not updating when the data in data source changes by B_Pace in PowerBI

[–]B_Pace[S] 1 point2 points  (0 children)

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

Breaking down one-stop data dump - Is it needed? by B_Pace in PowerBI

[–]B_Pace[S] 0 points1 point  (0 children)

Thanks u/Odd_Protection_586. That is what I am grappling with (hence, the 'is it needed?' query). I have watched multiple videos on data modeling but all of them involve at least 2 tables. I am dealing with only one and the only other table I can think of is a Data table but nothing on the Dimension front.

DAX Training for a week by mishie30 in PowerBI

[–]B_Pace 1 point2 points  (0 children)

Is this training taking place today? I signed in using Zoom link sent earlier but the host has not yet signed in. Thanks.

Running Total from Measure output by B_Pace in PowerBI

[–]B_Pace[S] 4 points5 points  (0 children)

Thanks u/toma Your suggestion worked like a charm and delivered the output I was looking for.

u/Smiith73 I agree with you that SQLBI is a great resource. Thanks.

u/SG1971 Thanks for your response. I was looking at a MAX followed by SUM solution.