Data factory Power Query is empty and not loading

Question

question

JaanPartna-5656 asked May 6, '22 PRADEEPCHEEKATLA-MSFT commented May 11, '22

Data factory Power Query is empty and not loading

The Power Query resource in Azure data factory is not showing anything and there are no errors.

The dataset is in Azure SQL and the data can be seen with Preview data, so this shouldn't be the problem.

azure-data-factory power-query-not-supported

image.png (36.0 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

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

PRADEEPCHEEKATLA-MSFT · May 10 at 07:51 AM

Hello @JaanPartna-5656,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

Please don't forget to click on or upvote button whenever the information provided helps you.

0 ·

Answer 1 · 2022-05-09T08:05:44.19Z

PRADEEPCHEEKATLA-MSFT answered May 9, '22 PRADEEPCHEEKATLA-MSFT commented May 11, '22

Hello @JaanPartna-5656,

Thanks for the question and using MS Q&A platform.

This is an excepted behaviour when you are running the Power Query which is not supported.

You may checkout the list of supported Power Query M function in Transformation functions in Power Query for data wrangling.

Hope this will help. Please let us know if any further queries.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

· 1

5 |1600 characters needed characters left characters exceeded

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

PRADEEPCHEEKATLA-MSFT · May 11 at 09:48 AM

Hello @JaanPartna-5656,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 ·

question