Forum Discussion

Gulan70's avatar
Gulan70
Frequent Visitor
7 years ago

Data Refresh online from SQL View blanks my data

I have a very simple report based on 1 SQL-View from SQL server. Gateway is installed for online.
Works fine in Power BI desktop: refresh works nicely (import).  I can see everything, data is updated.

Data and report are published in a Workspace so I see my simple report (count of all records) there.

 

Problem: When i refresh my data everything blanks on my report.

 

Now when i do the same but base my report on the SQL-table in stead of the View for that table, everything does refresh in Power BI online.

 

Where is something missing?