Power BI data doesn't show on Online version, only on Desktop version

[Anonymous]

Hello!

I've been having some issues with Power Bi Online.

When I created tables and visuals in power BI desktop, all data was appearing, but after publishing it to Power Bi Online, some data is not showing (1 specific field, named "Unidade"). 

I already changed the size of column. I also checked if ther were some filters applied, but nothing worked. 

For information: data comes from an excel spreadsheet.

Please see the following examples:

POWER BI DESKTOP

POWER BI ONLINE (after publishing)

Hope you can help me solve this issue. Thank you in advance!

[Anonymous]

Hello!

Yes, I think it's accessible. Also, other data from the same Spreadsheet is showing on the dashboard. Only field that doesn't appear is the "Unidade" column.

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

The data of the dataset has changed from desktop,due to the number hold over is 20 online. Maybe there is no data related to "Marca" in "unidade". Sometimes, the value "abc" in table A is related to the value "abc" in table B, so the relationship is well connected. However, if you insert some spaces in the value of table A, "abc ", this will result in a blank result, as you can see.

I recommand you to add one step to remove space in power query.

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous]

Thank you, it worked!

[ANTHE]

Hello,

Is your Excel sheet accessible by the Online Service ?
Check if the query to the Excel sheet refer to an online adress.