cancel
Showing results for 
Search instead for 
Did you mean: 
0

Needed help with pulling the data from Microsoft Datastudio

This is my first time using power bi web connector. 

I am trying to use PowerBi to pull the data from Microsoft Datastudio Dashboards. attaching where I am struck in the process. Could someone please help me where I am doing wrong or how I can proceed further.

 

Thanks

CSS_Selector_PBI.png

 

Status: Delivered
Comments
Moderator

@Rkaipu06,

Please enter several rows of sample data you would like to extract in column1 and column2 so that Power BI Desktop can recognize the whole table.

References:
https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example
https://www.poweredsolutions.co/2018/05/14/new-web-scraping-experience-in-power-bi-power-query-using...

Regards,
Lydia

Established Member
Status changed to: Delivered
 
Occasional Visitor
@v-yuezhe-msft Thank you for your response. But i did tried in the way you provided. CSS Selector is not recognizing the tables.
Moderator

@Rkaipu06

Could you please share the web link so that I can test? How about you enter the text and number in a single column?

Regards,
Lydia

Moderator

@Rkaipu06,

I am unable to extract table from the web page you share. Based on the link you share, it seems a report which containing different pages. What data source do you connect to when create the report? Why not directly connect to the data source in Power BI Desktop?

Regards,
Lydia

Idea Statuses