Data source query lock icon

ron barlow 411 Reputation points
2021-04-13T20:49:07.137+00:00

hello

I'm working on a PP model, but a number of the data sources have the lock icon. as per the attached image.

87504-iconw.jpg

The data source contains data from 3 sources. Two dB queries and a link to an excel file. In the applied steps on Power Query Editor, I don't have either the Edit Settings or View Native Query options.

A couple of questions.

What does the lock mean and how do I amend the query?

Thanks in advance
Roy

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,298 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-04-13T23:04:38.797+00:00

    I don't see a lock icon in the image you attached.

    My guess would be that you can't edit anything about these data sources in Power Pivot itself, since they were created in Power Query. Instead, you have to edit them in PQ.

    0 comments