Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
MikeMyers
New Member

You are not authorized to perform this operation

I have a power query using an ODBC connection to a Pervasive database. It was developed on the same machine I am now getting the error on. It worked then but something happened and now it gives this error. The query will run on one machine that I am aware of, but on all others I get this error. I have no idea how to approach fixing this. Please help.  

 

Snap1.jpeg

Advanced Editor:

let
Source = Odbc.Query(fParameter("ParameterTable","DataBase"), fParameter("ParameterTable","CODE"))
in
Source

 

Parameter Table:Capture.JPG

 

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

Check the Data Source Settings and see if it defaulted to Anonymous or the credentials need to be updated.  They may be encrypted/cached on the original and not the new laptop.

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Microsoft Employee
Microsoft Employee

Check the Data Source Settings and see if it defaulted to Anonymous or the credentials need to be updated.  They may be encrypted/cached on the original and not the new laptop.

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Yes, sir.  That worked!  

 

Thank you Pat

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.