Forum Discussion

Simon911's avatar
Simon911
Regular Visitor
9 years ago
Solved

Handling multiple sendgrid accounts

I have been importing data from 5 different sendgrid accounts but as the import url is same "https://api.sendgrid.com/v3/stats" i am having problems refreshing the data. I have save data for one acco...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Simon911

     

    In Power BI, we can use query parameter to configure a dynamic data source, but it can't be used on Power BI Services. It can't be resolved by gateway either.

     

    In this scenario, you should refresh all 5 accounts data. If you have a super account which can view all 5 account data, you should use this account credential in gateway, and set Row Level Security to limit data access for different account. Otherwise, you have to create 5 dataset, and configure 5 individual gateways with different accounts for each dataset.

     

    Regards,

Simon911's avatar
Simon911
Regular Visitor
9 years ago

ankitpatira Can you give me an example or can you tell me how can i configure query parameter for sendgrid accounts? I tried but could not get through it. It eventually considers the data source settings for the account and anyway i have to change it again when i have to import for other sendgrid account.

PBILover's avatar
PBILover
Helper V
5 years ago

 

Hi, I want to access the sendgrid data without any aggregate , is it possible to achieve this?

thanks .

v-sihou-msft    ,ankitpatira