Forum Discussion
Helper IVData disappears after refresh in PowerBI Service
Hope someone can help. I have a few reports created in PowerBI Desktop. They all work fine. The data connection is an import connection from our SQL database. When I publish these reports to PowerBI Service everything is fine. Data and visuals all fine. We use an onpremises data gateway and all appears okay. Then, in PowerBI service, if I go to Datasets and refresh the data, the data from some SQL views disappears. You briefly see the data but then the visual becomes blank. The only way to get the data back again is to re publish the report from the desktop. In PowerBI Service I have also scheduled refreshes overnight but they fail for some reason. Clearly there is a problem with my data source but I cannot find it at all. No error messages are shown in the desktop or in the service. I receive an email when the refresh fails but it has no detail about the problem, just - "Oops - something went wrong". I have read other things on this topic - I do not use any booleans in filters which may cause a problem between the desktop and the service.
I am tearing my hair out trying to find a solution. Any ideas on where I can look for any problems with my data when I refresh in the service?
5 Replies
v-jiascu-msftMicrosoft Employee
Hi dphillips,
If it's possible that the data source (the SQL database) has no data. Therefore, the refresh will clear the old data. And the result will be empty. Because, the refresh in Power BI is full refresh rather than incremental refresh. Please check out the status of the data source.
Best Regards,
Dale
dphillipsData source looks okay. In the desktop, I can refresh and all the information is there. It is only when I refresh in the web app that all the data disappears for one particular table only. One of the tables is okay but two others lose their data. why would it effect only some tables and not others?
mark_carlisleAdvocate IV
I know this is an old thread but did you manage to resolve this?