Session and PageView are empty for BC 18 and Dynamics 365 Business Central Usage Version 344

[OUAIRY]

Hello,

I want connect app power BI Business Central Usage Version 344 with a Business Central 18.2. But I have a problem because I don't have any value in page Session and Page View (by exemple), I have data for report (telemetry is ok).

Do you have any ideas or settings to make ?

Thank you for your help.

[KennieNP]

Try running the KQL query on the bottom of the PBI page. Does this show any data?

…

On Wed, 19 Jul 2023 at 17:41, Jean-Charles OUAIRY ***@***.***> wrote: Hello, I want connect app power BI Business Central Usage Version 344 with a Business Central 18.2. But I have a problem because I don't have any value in page Session and Page View (by exemple), I have data for report (telemetry is ok). Do you have any ideas or settings to make ? Thank you for your help. — Reply to this email directly, view it on GitHub <#201> or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXE6SZI3RZJ6R6AUHIB253XQ752RBFKMF2HI4TJMJ2XIZLTSOBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJLJONZXKZNENZQW2ZNLORUHEZLBMRPXI6LQMWBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTLDTOVRGUZLDORPXI6LQMWSUS43TOVS2M5DPOBUWG44SQKSHI6LQMWVHEZLQN5ZWS5DPOJ42K5TBNR2WLKJRGU3TMOBZGMZTHAVEOR4XAZNFNFZXG5LFUV3GC3DVMWVDCOBRGIZDEMZQHE42O5DSNFTWOZLSUZRXEZLBORSQ> . You are receiving this email because you are subscribed to this thread. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

--

--------------------------------------------------- Kennie Nybo Pontoppidan Email: ***@***.*** Twitter: @KennieNP www and cv: http://pontop.dk ---------------------------------------------------

[OUAIRY]

Hi @KennieNP,

I try to execute query : I have no result but if i delete filter on RT0003, I success

I find that RT0003 had add in BC22, but can i change the request in App Power BI ? Or install an old version ? How to do ?

// change lookback, limit, ... as needed
// SessionPerformance
let auth_step_one =
traces
| where timestamp >= ago(90d) // adjust as needed. The value 90 comes from the app configuration
| where customDimensions has 'RT0003'
| where customDimensions.eventId == 'RT0003'
| where isnotempty(customDimensions.aadTenantId) // filter away signal from Docker sandboxes
| extend AadTenantId = tostring( customDimensions.aadTenantId )
, EnvironmentName = tostring( customDimensions.environmentName )
| extend TenantId = strcat( toupper(AadTenantId), toupper(EnvironmentName) )
| extend userType = tostring( customDimensions.userType )
| project timestamp
, AadTenantId, EnvironmentName
, EnvironmentType = tostring( customDimensions.environmentType )
, TenantId
, PlatformVersion = tostring( customDimensions.componentVersion )
, GuestUser = tostring( customDimensions.guestUser )
, UserType = case(
userType == 'INTERNAL_ADMIN', 'Administrator'
, userType == 'Normal', 'Normal User'
, userType
)
, session_Id
;
let auth_step_two =
traces
| where timestamp >= ago(90d)
| where customDimensions has 'RT0002' or customDimensions has 'RT0004'
| where customDimensions.eventId in ( 'RT0002', 'RT0004' )
| extend AadTenantId = tostring( customDimensions.aadTenantId )
, EnvironmentName = tostring( customDimensions.environmentName )
| extend TenantId = strcat( toupper(AadTenantId), toupper(EnvironmentName) )
| project ClientType = tostring( customDimensions.clientType )
, session_Id
;
auth_step_one
| join kind=inner auth_step_two on $left.session_Id == $right.session_Id
| project-away session_Id, session_Id1
| summarize count=count()
by bin(timestamp, 1h)
, AadTenantId, EnvironmentName, EnvironmentType, TenantId
, PlatformVersion, ClientType, GuestUser, UserType
// change/remove the next line (take 10). It is just here to make the first run of the query fast
| take 10

[KennieNP]

I am on vacation, but will try to fix this for the August 2023 update

…

On Thu, 20 Jul 2023 at 09:58, Jean-Charles OUAIRY ***@***.***> wrote: Hi @KennieNP <https://github.com/KennieNP>, I try to execute query : I have no result but if i delete filter on RT0003, I success I find that RT0003 had add in BC22, but can i change the request in App Power BI ? Or install an old version ? How to do ? // change lookback, limit, ... as needed // SessionPerformance let auth_step_one = traces | where timestamp >= ago(90d) // adjust as needed. The value 90 comes from the app configuration | where customDimensions has 'RT0003' | where customDimensions.eventId == 'RT0003' | where isnotempty(customDimensions.aadTenantId) // filter away signal from Docker sandboxes | extend AadTenantId = tostring( customDimensions.aadTenantId ) , EnvironmentName = tostring( customDimensions.environmentName ) | extend TenantId = strcat( toupper(AadTenantId), toupper(EnvironmentName) ) | extend userType = tostring( customDimensions.userType ) | project timestamp , AadTenantId, EnvironmentName , EnvironmentType = tostring( customDimensions.environmentType ) , TenantId , PlatformVersion = tostring( customDimensions.componentVersion ) , GuestUser = tostring( customDimensions.guestUser ) , UserType = case( userType == 'INTERNAL_ADMIN', 'Administrator' , userType == 'Normal', 'Normal User' , userType ) , session_Id ; let auth_step_two = traces | where timestamp >= ago(90d) | where customDimensions has 'RT0002' or customDimensions has 'RT0004' | where customDimensions.eventId in ( 'RT0002', 'RT0004' ) | extend AadTenantId = tostring( customDimensions.aadTenantId ) , EnvironmentName = tostring( customDimensions.environmentName ) | extend TenantId = strcat( toupper(AadTenantId), toupper(EnvironmentName) ) | project ClientType = tostring( customDimensions.clientType ) , session_Id ; auth_step_one | join kind=inner auth_step_two on $left.session_Id == $right.session_Id | project-away session_Id, session_Id1 | summarize count=count() by bin(timestamp, 1h) , AadTenantId, EnvironmentName, EnvironmentType, TenantId , PlatformVersion, ClientType, GuestUser, UserType // change/remove the next line (take 10). It is just here to make the first run of the query fast | take 10 — Reply to this email directly, view it on GitHub <#201 (comment)> or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXE6S5R4ASECAUW7Z4XD4TXRDQIXBFKMF2HI4TJMJ2XIZLTSOBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTAVFOZQWY5LFUVUXG43VMWSG4YLNMWVXI2DSMVQWIX3UPFYGLLDTOVRGUZLDORPXI6LQMWWES43TOVSUG33NNVSW45FGORXXA2LDOOJIFJDUPFYGLKTSMVYG643JORXXE6NFOZQWY5LFVEYTKNZWHA4TGMZTQKSHI6LQMWSWS43TOVS2K5TBNR2WLKRRHAYTEMRSGMYDSONHORZGSZ3HMVZKMY3SMVQXIZI> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

--

--------------------------------------------------- Kennie Nybo Pontoppidan Email: ***@***.*** Twitter: @KennieNP www and cv: http://pontop.dk ---------------------------------------------------

[OUAIRY]

Thank you, no problem good vacation !
(I think I have the same problem on PageView, the filter on CL0001 is not ok).

[OUAIRY]

Hi @KennieNP, Have you had a chance to have a look?

Thank You !

[KennieNP]

This has been fixed in the September update

…

On Mon, 28 Aug 2023 at 17:34, Jean-Charles OUAIRY ***@***.***> wrote: Hi @KennieNP <https://github.com/KennieNP>, Have you had a chance to have a look? Thank You ! — Reply to this email directly, view it on GitHub <#201 (comment)> or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXE6S2LUM7HI6K4REEBQW3XXS3ANBFKMF2HI4TJMJ2XIZLTSOBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTAVFOZQWY5LFUVUXG43VMWSG4YLNMWVXI2DSMVQWIX3UPFYGLLDTOVRGUZLDORPXI6LQMWWES43TOVSUG33NNVSW45FGORXXA2LDOOJIFJDUPFYGLKTSMVYG643JORXXE6NFOZQWY5LFVEYTKNZWHA4TGMZTQKSHI6LQMWSWS43TOVS2K5TBNR2WLKRRHAYTEMRSGMYDSONHORZGSZ3HMVZKMY3SMVQXIZI> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

--

--------------------------------------------------- Kennie Nybo Pontoppidan Email: ***@***.*** Twitter: @KennieNP www and cv: http://pontop.dk ---------------------------------------------------

[JOUAIRY]

Hi @KennieNP, I will remind you of the problem because I have always chosen the same thing, no data appears when I use an OnPrem database whether in BC18 or BC23

[KennieNP]

Did you update the pbi app to the latest version?

…

On Wed, 17 Jan 2024 at 14:38, Jean-Charles OUAIRY ***@***.***> wrote: Hi @KennieNP <https://github.com/KennieNP>, I will remind you of the problem because I have always chosen the same thing, no data appears when I use an OnPrem database whether in BC18 or BC23 — Reply to this email directly, view it on GitHub <#201 (comment)> or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABXE6S4S7KXVMZM6SURQ3ETYO7H35BFKMF2HI4TJMJ2XIZLTSOBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTAVFOZQWY5LFUVUXG43VMWSG4YLNMWVXI2DSMVQWIX3UPFYGLLDTOVRGUZLDORPXI6LQMWWES43TOVSUG33NNVSW45FGORXXA2LDOOJIFJDUPFYGLKTSMVYG643JORXXE6NFOZQWY5LFVEYTKNZWHA4TGMZTQKSHI6LQMWSWS43TOVS2K5TBNR2WLKRRHAYTEMRSGMYDSONHORZGSZ3HMVZKMY3SMVQXIZI> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .

--

--------------------------------------------------- Kennie Nybo Pontoppidan Email: ***@***.*** Twitter: @KennieNP www and cv: http://pontop.dk ---------------------------------------------------

[JOUAIRY]

Yes, i download the last version for test on BC23. I have always no telemetry for page views :(

[frottke]

We have the same issue with BC24 Cloud and OnPrem. Is there a solution? We had the idea that it might be due to the Azure region. This does not seem to be the case. It looks like that UBlock Origin (Adblocker) is the root cause. Is it correct that no page views are emitted when an ad blocker is used?

Even without ad blocker ->
It works in the environment telemetry but not in the app telemetry. Strange!

[JOUAIRY]

Strange, for me It's ok in BC23 Saas FR but not in OnPrem only