Copied values when data is imported

[Anonymous]

Hi,

I'm working with google form data that is published to Google Sheets and exported as PUBHTML format. When I imported the data to PBI, the values of one column will be copied to the next / the next two columns if they are blank. Has anyone encountered this issue?

A sample of the error is provided below.

Top is the original data from the survey Thank you for your help.

[v-eqin-msft]

Hi @Anonymous ,

Please kindly take a look at these for reference.

https://community.powerbi.com/t5/Desktop/Google-Sheets-Connection-Broken/td-p/1184701

https://community.powerbi.com/t5/Power-Query/How-to-connect-google-sheet-to-Power-BI/td-p/14587

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

[amitchandak]

@Anonymous , This can happen because of a broken tag if you are using HTML/WEB import.

what is the method you are using?

The one used in this post to read google sheet?

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Write-Back-From-BI/m-p/1044976#M16

[Anonymous]

Hello,

After reading the post, yes I pasted the web URL directly to my PBI just like your reference. Do you know how to fix the issue? Thank you.