search

microsoft / BCTech

Business Central technology samples
MIT License
575 stars 307 forks source link

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

Open OUAIRY opened 1 year ago

OUAIRY commented 1 year ago

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 commented 1 year ago

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 https://github.com/microsoft/BCTech/issues/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 commented 1 year ago

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 commented 1 year ago

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 https://github.com/microsoft/BCTech/issues/201#issuecomment-1643456494 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 commented 1 year ago

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

OUAIRY commented 1 year ago

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

Thank You !

KennieNP commented 1 year ago

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 https://github.com/microsoft/BCTech/issues/201#issuecomment-1695910063 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 commented 10 months ago

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 commented 10 months ago

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 https://github.com/microsoft/BCTech/issues/201#issuecomment-1895831754 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 commented 9 months ago

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

frottke commented 7 months ago

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 commented 7 months ago

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