cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mleijzer
Regular Visitor

Getting SQL on-premis data error

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Getting SQL on-premis data error

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

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Re: Getting SQL on-premis data error

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

View solution in original post

mleijzer
Regular Visitor

Re: Getting SQL on-premis data error

Yes, you are right, thanks for helping!

Highlighted
mleijzer
Regular Visitor

Re: Getting SQL on-premis data error

I forgot, indeed I do not have a premium account, so that's the problem.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,631)