Web Query

[Anonymous]

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.

[Fowmy]

@Anonymous 

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

[Anonymous]

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

[Fowmy]

@Anonymous 

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: 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

[amitchandak]

@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

[Anonymous]

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