POWER BI Service Refresh issue - Refresh is not supported for datasets with a calculated table

to resolve this problem is easy, you just need import the table on power query using analysis server component and put the correct server:

to find the correct server you can see on the schedule refresh page on power bi service, like this:

and after put the result on power query (dont forget put IMPORT)

in this example i selected a virtual table named "lojas tumelero"(but you can put any kind of table), and with this you can do what you need, and error doesn't happen anymore