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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
karkar
Helper III
Helper III

NATIVE QUERIES

Hello,

 

I have initially built a query in Power Bi after connecting to SQL database. 

 when I try to refresh the query on my computer, it pops something about NATIVE DATABASE QUERIES.

Could someone help me resolve the issue?

 

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @karkar

 

You can disable this warning message go to -->File-->Options & Settings-->Options

 

Capture.PNG

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @karkar

 

You can disable this warning message go to -->File-->Options & Settings-->Options

 

Capture.PNG

 

Thanks Baba,

 

Just wanted to majke sure that doing so would not mess anything like alteringthe database/something unsafe?? as this is the message i get:

 

"Native queries may be unsafe and alter th edatabase. Because native queries maybe rerun multiple times , those which do alter the database may result in incorrect or unpredictable behavious:"

 

Thank you again

Anonymous
Not applicable

Yes but it's showing you a message because it's enabled in your options...you should know what exactly the query is.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.