search

sql-bi / Pbi-PushDataset

Validate and translate regular Tabular models in Push Datasets, also providing helper functions to clear, populate, and simulate real-time transactions.
MIT License
49 stars 15 forks source link

Writing data in push dataset (simulation) - error on simulation json file - Sqlbi.PbiPushDataset.SimulationType #8

Closed shadigolzarpour closed 2 years ago

shadigolzarpour commented 2 years ago

hi there i keep getting errors when i try to generate simulation json file for my data fields, where can i find the exact data type that is accepted Sqlbi.PbiPushDataset.SimulationType, here is the exact error Unhandled exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Newtonsoft.Json.JsonSerializationException: Error converting value "string" to type 'Sqlbi.PbiPushDataset.SimulationType'. Path 'tables[0].columns[0].type', line 10, position 36. ---> System.ArgumentException: Requested value 'string' was not found.

marcosqlbi commented 2 years ago

Can you share the configuration file you used and the definition of the table you are trying to use? Thanks!

shadigolzarpour commented 2 years ago

Thanks for your reply , I managed to fixed the file by removing the data type . Thanks for your reply

However I have another question . I have used batch row for my POC demonstration. But I want to automate it and configuration happens dynamically .

When I removed the batch number from the file , 0 rows gets updated . Everytime I have different number of rows , how can I implement this on my config file ?

Thanks Shadi

From: Marco Russo @.> Sent: Saturday, March 19, 2022 7:32:58 AM To: sql-bi/Pbi-PushDataset @.> Cc: Shadi Golzarpour @.>; Author @.> Subject: Re: [sql-bi/Pbi-PushDataset] Writing data in push dataset (simulation) - error on simulation json file - Sqlbi.PbiPushDataset.SimulationType (Issue #8)

Can you share the configuration file you used and the definition of the table you are trying to use? Thanks! — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for ‍ ‍ ‍ ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. Caution: Do not click links or open attachments unless you can confirm the sender and know the content is safe. If in doubt, forward to @.*** ZjQcmQRYFpfptBannerEnd

Can you share the configuration file you used and the definition of the table you are trying to use? Thanks!

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/sql-bi/Pbi-PushDataset/issues/8*issuecomment-1072691772__;Iw!!P2PMt_zn!Qtd9QGF5JCZGgvXHc4ANlpNxG9BMDZC0iEXEKRBYj2hl1VGCPRK0gfMvu2ZrVY2seYY96QKlniA$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/ASHUMSN26MHLWTRCMFM7CI3VATD5VANCNFSM5Q72WXGA__;!!P2PMt_zn!Qtd9QGF5JCZGgvXHc4ANlpNxG9BMDZC0iEXEKRBYj2hl1VGCPRK0gfMvu2ZrVY2seYY98nM_cHI$. Triage notifications on the go with GitHub Mobile for iOShttps://urldefense.com/v3/__https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675__;!!P2PMt_zn!Qtd9QGF5JCZGgvXHc4ANlpNxG9BMDZC0iEXEKRBYj2hl1VGCPRK0gfMvu2ZrVY2seYY9heTBwpg$ or Androidhttps://urldefense.com/v3/__https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__;JSUlJSU!!P2PMt_zn!Qtd9QGF5JCZGgvXHc4ANlpNxG9BMDZC0iEXEKRBYj2hl1VGCPRK0gfMvu2ZrVY2seYY9W4fVIb8$. You are receiving this because you authored the thread.Message ID: @.***>

This email with any attachments is confidential and may be subject to legal privilege. If it is not intended for you please reply immediately, destroy it and do not copy, disclose or use it in any way.

marcosqlbi commented 2 years ago

Sorry I don't understand the question. Can you clarify?

shadigolzarpour commented 2 years ago

Sure

In the sample file you have batch row = 98 , so only 98 rows will get refreshed . In my example everytime the new data comes through I have different number of rows . They are not fixed number of rows , how can I implement this on the configuration file where batch row is different in every refresh ?

From: Marco Russo @.> Sent: Saturday, March 19, 2022 8:58:58 AM To: sql-bi/Pbi-PushDataset @.> Cc: Shadi Golzarpour @.>; Author @.> Subject: Re: [sql-bi/Pbi-PushDataset] Writing data in push dataset (simulation) - error on simulation json file - Sqlbi.PbiPushDataset.SimulationType (Issue #8)

Sorry I don't understand the question. Can you clarify? — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. Caution: Do not click links or open attachments unless you can confirm the sender and know the content is safe. If in doubt, forward to @.*** ZjQcmQRYFpfptBannerEnd

Sorry I don't understand the question. Can you clarify?

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/sql-bi/Pbi-PushDataset/issues/8*issuecomment-1072755581__;Iw!!P2PMt_zn!VQnNMlM147SF8LHykPzydthueQ-iEaRAk3TJKCclvYnDPf7KfOFpsGdfUOFE_zRFeNwdujZ7aKw$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/ASHUMSKN3REXSHJ5JKEKKOTVATOAFANCNFSM5Q72WXGA__;!!P2PMt_zn!VQnNMlM147SF8LHykPzydthueQ-iEaRAk3TJKCclvYnDPf7KfOFpsGdfUOFE_zRFeNwdPgtZuRQ$. Triage notifications on the go with GitHub Mobile for iOShttps://urldefense.com/v3/__https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675__;!!P2PMt_zn!VQnNMlM147SF8LHykPzydthueQ-iEaRAk3TJKCclvYnDPf7KfOFpsGdfUOFE_zRFeNwdqRfAjto$ or Androidhttps://urldefense.com/v3/__https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__;JSUlJSU!!P2PMt_zn!VQnNMlM147SF8LHykPzydthueQ-iEaRAk3TJKCclvYnDPf7KfOFpsGdfUOFE_zRFeNwdvDVT9fc$. You are receiving this because you authored the thread.Message ID: @.***>

This email with any attachments is confidential and may be subject to legal privilege. If it is not intended for you please reply immediately, destroy it and do not copy, disclose or use it in any way.

marcosqlbi commented 2 years ago

The number of rows in a batch is fixed in the simulation. For the purposes of the simulation, it should be enough. If you want to change it dynamically, you should change the code here: https://github.com/sql-bi/Pbi-PushDataset/blob/a2d88287a61f05a9f8b13534046098e555b0751e/Sqlbi.PbiPushDataset/PbiConnection.cs#L442