PowerBI and Google Sheets

[Anonymous]

Hello, 

Hi, 

I have got CSV data held in google sheets to power BI but unable to promote first row as header as suggested in 
https://community.fabric.microsoft.com/t5/Power-Query/Connect-to-Google-Sheets/td-p/612193

I have a MAC and do not have access to PowerBI desktop and everyting needs to done using web app

Any recommendations?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

What do you mean by "everyting needs to done using web app"? Are you using Power BI Service?
Promote first row as header can only be achieved in Power Query Editor, if you are using Power BI Service, you can't do that.

Here's an alternative approach:
Before importing your data into Power BI, ensure the first row in your Google Sheets document accurately represents the headers you wish to use. This preparation step can help mitigate the need to promote rows as headers within Power BI.

Or I suggest you setup a VM with windows and use Power BI Desktop in the VM.

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