Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have seven queries inside the dataflow, created exactly in this order:
I see the preview of all queries, but I am unable to save the dataflow (see the screenshot above).
Here's what I tried:
I added back query E -- the dataflow saved all right. Then I added back query A and it failed to save again.
Here's the M script of query A:
let Source = Excel.Workbook(File.Contents("********.xlsx"), null, true) in Source
I know for a fact that my gateway can access this file because I am using queries A-G in my .pbix file, which refreshes all right.
Finally, I tried to play with the third argument of Excel.Workbook -- setting it to false or null did not help, unfortunately.
What am I doing wrong?
P. S. There should be an Idea Label on this forum for dataflows and apps (there is one for Content Packs but they're deprecated!).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.