Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unable to convert an M query in table '[Dataset Table]' into a native source query.

Dear Team,   Looking for help the the error that couldn't load the data for this visual Error prompt "Unable to convert an M query in table '[Dataset Table]' into a native source query."   No is...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks Anonymous , i have went through the post you share, however the issue seem different.

    Just for the info, the power bi vis is working in web for sometime, just recently (ermm, around 2 to 3 weeks ago..) not function. Just afraid the recent upgrade for power bi will impact. Any other suggestion?

     

    Just to highlighten,

    1) no issue for the Desktop base, the issue only happen during the web base after publish to web.

    2) gateway setting is successful and connected.

     

     

    I reinstall again the Powerbigateway again today, it work now.. Roots cause unknown.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Anonymous , i have went through the post you share, however the issue seem different.

Just for the info, the power bi vis is working in web for sometime, just recently (ermm, around 2 to 3 weeks ago..) not function. Just afraid the recent upgrade for power bi will impact. Any other suggestion?

 

Just to highlighten,

1) no issue for the Desktop base, the issue only happen during the web base after publish to web.

2) gateway setting is successful and connected.

 

 

I reinstall again the Powerbigateway again today, it work now.. Roots cause unknown.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This error seems to be a wide net that catches a lot of M compiler type problems, it seems.  Anyway, I did this and it gave relief:

  1. Using the Pbi query editor...
  2. Disable load on any/all data sets. Save.
  3. Enable load on any/all data sets. Save.

Try again.

  • Cbutler's avatar
    Cbutler
    Icon for Helper III rankHelper III
    5 years ago

    hi Anonymous , aplogies for the basic question, I can not find where to disable/enable to load in query editor. Can you provide some steps please. 

    Thanks 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      In the Power Bi query editor where you have all the heavy tools for transforming etc... Simply right click on the the data source (should be on the left side of the screen) and un/choose Enable load.    

      • Cbutler's avatar
        Cbutler
        Icon for Helper III rankHelper III
        5 years ago

        Thanks, found it. Didn't work for me though 😞

  • jolano's avatar
    jolano
    New Member
    4 years ago

    Worked for me!!

    I had to recreate a few measures again after reloading, hopefully I had a recent backup of those measures.

     

    Make sure to Save after disable. Maybe it is obvious, but if you just disable and enable without saving nothing happens.

  • Shashanth's avatar
    Shashanth
    Frequent Visitor
    4 years ago

    I want to mark this as solution... But I am not sure.. How to do that