Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to connect to a db. I'm getting the name of the db but no tables.
This is what I've done so far
Now for authenticating I've tried
On the server side I've created an Engine DSN like in these Instructions
Has anyone here successfully pulled out data from Pervasive SQL v.13 with Power Query in Power BI Desktop ?
Please, share
Hi Yggdrasill,
Accorin to your description, it seems that you could connect to Pervasive SQL successfully, but you can't get the table from database, right? And it seems that when you use windows credential , it could work, right?
You need to make sure the user(which use database credential) have permission to these table. In addition, if you write the SQL query in advanced option, will you get table data?
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.