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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
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,