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
4 years ago

Hi Team, in my case the error was originated by the date table. I created the table with a

 

Dates = CALENDARAUTO (12)

 

and then some calculated columns like:

Month = MONTH('Date'[Date])
Month name = FORMAT('Date'[Date], "MMM")
Year = YEAR('Date'[Date])


The datasources created BEFORE the data table were created without any error.
But... any datasource added to the model AFTER the date table was created, caused this error to happen. So the "solution", if it can be called like that, was to remove the date table and then add the datasource, and then again add the date table at the end. I hope this helps anyone because it was a big headache until I figured this out. Can anyone explain this or give some hint about how to avoid the error without deleting the data table?