Multiple Stripe Data Connections

Hi Lydia and thanks for replying.

(I had a lot of difficulty replying to the post, it kept saying successful, but hadn't actually posted anything.......)

I'll try to clarify.

Last week I built 2 x reports in the Power BI Desktop, which both have a data connection using the Get Data Stripe service.

Each report concerns a different brand of the same client / business, our single login to Stripe accesses both brand accounts but each of the businesses brands has its own authentication key in Stripe. I expect this is simialr for many SaaS solutions online.

So, I created a .pbix for brand 1 in Power Bi desktop, get data for Stripe, input authentication key 1, select and transform the required data, build the report, publish the report to my workspace on app.powerbi.com and schedule an overnight refresh.

All looks good.

I create a second .pbix for brand 2 in Power Bi desktop, get data for Stripe, input authentication key 2, select and transform the required data, build the report, publish the report to my workspace on app.powerbi.com and schedule another overnight refresh for this separate data set.

All looks good, both when viewing the reports and the data sets.

When I returned to Power Bi desktop this week and refreshed the data both reports were showing the same numbers / data / facts for brand 2.

Evidently the global permissions on my local machine were only storing the most recent authentication. I understand this is a limitation of these connections on Power BI desktop currently? In effect I can only work on one report at a time as only one authentication key is held on my machine.

However online in my workspace there are no global permissions and there are two distinct reports with two distinct data sets, both using the Stripe connection with different keys.

However after refreshing the reports online, they too only show the data for the most recently authenticated key.

Is this just not possible?

I will try publishing them to separate workspaces next, perhaps that will allow 2 Stripe connections.

Hope that's clearer.

Thanks in advance.

W.