question

ronbarlow-5250 avatar image
0 Votes"
ronbarlow-5250 asked Ehren answered

Data source query lock icon


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



power-query-not-supported
iconw.jpg (2.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.