Partial upload of data from Desktop

[mbrierley]

I've looked at other posts on this matter and they all seem really old and not all that helpful to my current predicament.

I have a report in desktop that looks correct. But when its published, one of the fields is not pulling through. The field is appearing blank, yet in desktop it appears to be fine. I'm only connecting to one data source too. Yesterday, this seemed to affect only automatic refreshes, but today, I've tried it manually, and its still not pulling through. 

[mbrierley]

Hi @v-tianyich-msft thanks for the advice. The problem appears to have been fixed. I followed the link, filled in the details of the problem and I was supplied with a link to an article on common issues with publishing from desktop (see below). One of the suggestions was to clear the cached data, and its now feeding through 🙂  Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn

[v-tianyich-msft]

Hi @mbrierley ,

I'm very happy to hear that your problem has been solved!

Best regards,
Community Support Team_ Scott Chang

[mbrierley]

@v-tianyich-msft I've just looked at the report today, and its doing the same thing 😞 I've tried all the suggestions listed in the article, but to no avail.

[v-tianyich-msft]

Hi @mbrierley ,

First of all this data may be needed for the calculation table, so it causes the refresh to fail. If you need to partially upload, you can use the enable load function in powerquery by right clicking on the table and checking enable load

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[mbrierley]

Hi @v-tianyich-msft, thanks for your reply, but I'm afraid I don't understand. I'm not using a calculated table. The only source that I have is to SQL database. When I refresh this in Desktop, it pulls all the data back that I need. When I go to publish it in the online space, its not appearing. I'm presenting it using a table viz. In the example below, its the grade field that is not working. 

[v-tianyich-msft]

Hi @mbrierley ,

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best regards.
Community Support Team_Scott Chang