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.
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.
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.
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?
I didnt delete the permissions, the first few times I refreshed and published as I was not aware of the global permission.
Subsequently, I tried creating connection, publishing report 1, deleting the global connection, creating new connection, publishing report 2. Also didn't work.
Tested creating serparate workspaces for the individual brands but that also did not work. After the scheduled refresh overnight both reports show the same data.
It seems this just isn't supported currently and I expect it applies to other get data services.
The last thing I will be trying is creating the reports on Power BI desktop under different Windows profile logins, just waiting on IT to create the new accounts for me. I suspect the Power BI web service will still override the published multiple connections and use just one though.
Maybe time to scope alternatives.
How is the issue going?
Still awaiting on IT to create a second windows profile / login to at least test that as a workaround.
But having to use an alternative BI solution for the specific client requirement.