Web Query

Question

Hi, I have a situation where in I am trying to import a web table in Power Bi but onyl first 2 columns are coming when I connect it.

Source = https://airtable.com/shrSAi6t5WFwqo3GM/tblEzPQS5fnc0FHYR/viweyymxOAtNvo7yH?blocks=hide

This is a CSV sheet however only 2 columns appear when U connect it with BI.

Please help.

amitchandak · Answer

Anonymous , refer if these can help
https://community.powerbi.com/t5/Desktop/Power-BI-Import-data-from-web/td-p/145601
https://medium.com/@patilpoojaif/web-data-source-in-power-bi-7c43591b7b20
https://www.youtube.com/watch?v=JHDYi4r5NtI

fowmy · Answer

Anonymous&nbsp;Yes, it does show two fields, the structure of the page is such.Did you try to export to CSV? It gives all the fields you need.________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube, LinkedIn&nbsp;

anonymous · Answer

All of this I know, point is not that, point is when I download CSV file only 2 columns comes in, and nothing else.

anonymous · Answer

I dont want to download it, because this data refreshed everyday and I want to automate it.

fowmy · Answer

Anonymous&nbsp;Hope someone in the forum will help you with the web connector.However, I downloaded the file as CSV and got ALL 13 columns with data.File:&nbsp;https://1drv.ms/u/s!AmoScH5srsIYgYIJvF8LUQ81wX2TDQ?e=hfhguK________________________Did I answer your question? Mark this post as a solution, this will help others!.I accept KUDOS 🙂YouTube, LinkedIn

Forum Discussion

Web Query

5 Replies

Related content

Publicación web

Auto Refresh Power Query in Excel with Web Content Connection

Get data from Web

merging direct query queries

Multiple web queries