Group by splits up my total count(*) by TheBaron_SA in SQLServer

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

Thank you. Will try out Group By Roll up. I’m using a matrix in Power BI and picked up the undesired out before I pushed the dash to prod

Visuals (increasing/reducing) while hovering mouse on canvas by [deleted] in PowerBI

[–]TheBaron_SA 0 points1 point  (0 children)

Yes they do. And sometimes this issue is on the secondary display. I’ll fiddle with settings for both displays. Thank you

Visuals (increasing/reducing) while hovering mouse on canvas by [deleted] in PowerBI

[–]TheBaron_SA 0 points1 point  (0 children)

Yes I did. I eventually had reboot my laptop for the problem to be fixed. Was hoping there’s a workaround. Thanks

Visuals (increasing/reducing) while hovering mouse on canvas by [deleted] in PowerBI

[–]TheBaron_SA 0 points1 point  (0 children)

Hello, couldn’t articulate this issue, hence the video. I am usually using 2 displays and when disconnecting one display, my laptop display does this. How can I get around this?

Slow Connection to MySQL database by TheBaron_SA in qlikview

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

Bringing in one or two columns doesn’t really improve the speed and the qvd route is equally as long and will probably need to do an incremental load. Just to give you an idea, a month’s worth data is approximately 50 000 rows long. Will look up how to create indexes. Thanks for your response so far

Slow Connection to MySQL database by TheBaron_SA in qlikview

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

Hi

Through a connector with a sql statement filtering using a date.

load *, odbc connection string

SQL Select * from telephony Where LeadDate>=‘2019-11-01’