Filter data on basis of customer

[s3banerjee]

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]

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