I've been trying to connect to data from our on-premis SQL server.
I already have a gateway up and running for Power BI, this works excellent.
But when I try to get the data in Power Apps I get an "Unexpected error", see the attached file.
Mashup-text says: "section Section1"
I am absolutely sure I have the data settings and credentials set correctly, they're identical to the setting in power BI gateway.
Just don't know what I'm doing wrong here, I have seen some similar problems but none of the solutions seem to apply.
Thanks in advance.
Solved! Go to Solution.
Hi @mleijzer ,
Both on-premise gateways and SQL connector have recently become premium. As such you would need to have a license in order to be able to access this. Can you confirm me if you have a license that allows you to access this? (e.g. PowerApps Plan 1, Plan2, per user plan or per app plan).
If this is not applicable my suggestion would be to raise a Support Request in the Power Platform admin center, in order to troubleshoot this in more depth.
Hope this helped!
Regards,
Ricardo
Hi @mleijzer ,
Both on-premise gateways and SQL connector have recently become premium. As such you would need to have a license in order to be able to access this. Can you confirm me if you have a license that allows you to access this? (e.g. PowerApps Plan 1, Plan2, per user plan or per app plan).
If this is not applicable my suggestion would be to raise a Support Request in the Power Platform admin center, in order to troubleshoot this in more depth.
Hope this helped!
Regards,
Ricardo
Yes, you are right, thanks for helping!
I forgot, indeed I do not have a premium account, so that's the problem.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
219 | |
212 | |
84 | |
57 | |
36 |