You’re offline. This is a read only version of the page.
2
Hello,
I'm sharing an Excel (Mac) sheet with a power query
The query includes a link to an external CSV
Then I share the sheet with the excel built in share - send email functionality
When the recipient opens the sheet, the original power query is gone and it's substituted by another one
I also tried to save the Excel sheet with save as... macro enabled, but it didn't change anything.
Is this a bug, or intended behaviour?
How can I fix this?
Thanks
Zin
Hi Gao,
as you can see in the 2nd screenshot, my power query uses as source
Share
Report
All responses (
Answers (
Csv.Document(Web.Contents("https://xxx.blob.core.windows.net/yyy/yyy_orders.csv?sv=2021-10-04&st=2023-06-27T12%3A05%3A09Z&se=2053-06-28T12%3A05%3A00Z&sr=b&sp=r&sig=zzzz"), [Delimiter = ",", Columns = 10, Encoding = 65001, QuoteStyle = QuoteStyle.None]),
So, I'm using a link to a csv residing in an Azure blob. The data is not on my local machine. I don't understand why this is not transferred when sharing. Can't I simply share an XLS with an embedded PQ using data from the web?
Zin
