Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot Refresh Data Stack Overflow Error

I can successfully refresh my data on the Desktop. No issues. 

 

However, when I try to update my dataset on PBI Online service I get the following error:

 

The table that PBI says is the issue is seemingly random. In this case of the CLI_Logic table the only power query transformation I'm using is "Change Type"

 

I am using dataflow for some queries. But the table given in this error is a simple SQL Server query.

Any ideas?

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Found a fix. In my case, I had a SQL query that worked with a relative reference within PowerBI desktop but needed an absolute table reference when on PBI service. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Found a fix. In my case, I had a SQL query that worked with a relative reference within PowerBI desktop but needed an absolute table reference when on PBI service.