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