search

microsoft / peek

Azure Usage/Billing Analytics Solution for EAs, CSPs and Direct Subscriptions.
77 stars 48 forks source link

Filter data on basis of customer #39

Open s3banerjee opened 7 years ago

s3banerjee commented 7 years ago

Hi ,

Here we want to fetch the data for one client/customer , i think we have 2 option , please correct if i'm wrong

a. Pull all the data for all customer from CSP site and put the data in SQL Azure database as we have 3 tables ( CspBillingData, CspSummaryData and CspUsageData ) for csp and we want to pull the data for 1 customer about the daily billing ,usage and consumption, how we can achieve , can you guide please ?

b. If possible, can we filter down the data from web.config (BillingdataAPI) while passing down the information to SQLAzure database based on 1 customer/client.

Can you provide some light on above please.

Thanks,

Saurabh

How we can fetch data SQL Azure database based on client/customer or any prior filter possible in the web.config of BillingdataAPI so the data stored in SQL AZURE database based on one client only

ssugar commented 7 years ago

@s3banerjee look at https://github.com/Microsoft/peek/blob/master/PowerBITemplates/Customer%20specific%20views/HowToCreateCustomerViews.md