Forum Discussion
Multiple Stripe Data Connections
Hi,
Relative newcomer to PowerBI but have been enjoying explorign the capabilites.
Have stumbled across a little problem with multiple data connections to the same service but with different authentication keys.
A business uses Stripe for payment services and they have multiple account behind their Stripe login for each individual brand associated with the business.
As such each account has its own secret key for data connections. I have built individual brand level reports which are working fine.
But it seems when I update the keys either in desktop prior to publishing, or directly via app.powerbi.com, the most recent authentication key takes over both connections resulting in identical data counts post refresh.
The data sets have their own namaes and are published separately.
I could have sworn this was working last week but having no luck this week.
Hopefully a simple knowledge base issue.
Thanks.
W
9 Replies
Waldie,
I am not very clear about your scenario. Could you please post the connections in your Power BI Desktop and Power BI Service? Do mask sensitive data before uploading connection strings.
Regards,
LydiaHi 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.
Waldie,
When you cconnect to Stripe data in the second PBIX file, do you delete the permissions for the existing stripe data source under global permissions?
Regards,Lydia
