cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AntonC Frequent Visitor
Frequent Visitor

Refresh data on PowerBI online not working

Hello,

 

I am working on a PowerBI report with a connection to an Azure database.

When refreshing the data in PowerBI Desktop it goes fine,  when I upload it to PowerBI Online the data is still visible. The problem occurs when a refresh takes place in PowerBI Online. Most data will refresh, but some does not. 

I downloaded the file back from PowerBI Online and I saw that a calculated column was empty (which should not be the case). I also see that this calculated column depends on another column to show 'True' or 'False', but when I download it from Power BI Online this column shows -1 or 0. I think the problem is because of this, but the next question: how do I solve it? 

 

Can somebody help me with this problem as a refresh of data on PowerBI Online is failing. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
AntonC Frequent Visitor
Frequent Visitor

Re: Refresh data on PowerBI online not working

In the meantime I fixed it myselfSmiley Very Happy 

 

It had to do with the true/false modelling of the column. Setting it to text in the advanced query editor was the solution.

 

Learned something more nowSmiley Very Happy

 

1 REPLY 1
Highlighted
AntonC Frequent Visitor
Frequent Visitor

Re: Refresh data on PowerBI online not working

In the meantime I fixed it myselfSmiley Very Happy 

 

It had to do with the true/false modelling of the column. Setting it to text in the advanced query editor was the solution.

 

Learned something more nowSmiley Very Happy