+ Reply to Thread
Results 1 to 3 of 3

Power Query issue Corrected M Code

  1. #1
    Registered User
    Join Date
    08-24-2017
    Location
    DUBAI UAE
    MS-Off Ver
    2021
    Posts
    81

    Power Query issue Corrected M Code

    i tried to use Power Query to transform data from a multiple worksheets in current workbook that contain only worksheets contained title "Rosetr" but i always receive this issue "Expression.SyntaxError: Token ',' expected" i tried many way and its not working . i need the correct Corrected M Code to be used perfectly for this scenario . the worksheet also expected to be dleted or new worksheet is going to be created . so i want this to work dinamically update

    image.jpg
    image1.jpg

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    10-05-2024
    Location
    Ukraine
    MS-Off Ver
    2021
    Posts
    101

    Re: Power Query issue Corrected M Code

    Hello! In a fugitive consideration, I saw that you have no closing bracket in a step Cleaneddata. It must be so
    Please Login or Register  to view this content.
    If you feel that I helped, can add a reputation.

  3. #3
    Registered User
    Join Date
    08-24-2017
    Location
    DUBAI UAE
    MS-Off Ver
    2021
    Posts
    81

    Re: Power Query issue Corrected M Code

    Thank you, I did what you mentioned but I'm getting error!

    Please Login or Register  to view this content.
    instead, I'm using the below and it's working great now

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query Experts Add file picker and pass data to the query issue
    By Belinea2010 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-29-2024, 04:04 AM
  2. [SOLVED] Strange Power Query Issue
    By IdabaMalouki in forum Excel General
    Replies: 22
    Last Post: 04-27-2024, 10:30 AM
  3. Issue with getting content from files using Power Query
    By Spocker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2021, 03:03 PM
  4. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. Power Query import issue
    By kao in forum Excel General
    Replies: 30
    Last Post: 01-13-2018, 06:13 PM
  6. Power Query Issue
    By TheDtox in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-27-2017, 05:43 AM
  7. Power Query Issue
    By TheDtox in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-27-2017, 02:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1