Forum Discussion
Problems with datetime and time formats
mariusla , if the Null/Blank values are text like NULL as a text value. Ideally power BI will show blank for Null. Or some space.
Use the trim and replace null with blank(), if you any such values. Or split the column and append back in a new column and remove unwanted stuff
Hi
I have considered the split and concatenate option but find it very non-effective. It can't by like this. So my question is:
1) When I get data from BigQuery to the PBI Dataflow, the datetime and time columns shows no errors.
2) When I get data from BigQuery directly in PBI Desktop the datetime and time columns shos no errors and Null are handled.
3) When i connect to the dataflow 1) with PBI Desktop the datetime and time columns shows the mentioned errors.
I cant find any reasonable explanation for this.
Marius