Cannot Display Table tab on NAVIGATOR of Power Query - Connect SFDC data to excel

[Kimot0407]

Hi Every one,

i have a question related to connection between SFDC (Web source data base) and Excel through Power queri - when i run the GET DATA from DATA tabular tab, get web Source and paste SFDC report link to that and run - the pop-up tab appears as the image below just displau: TEXT with HTML code and Displayed Text - i cannot transform to excel file from these two text.

in the past, when i run the same method - the display was a table and edit in Power query feature to run excel.

Thank alot

[Kimot0407 · Accepted solution]

hi @Anonymous , Thank for your suggestion - i tried that one, unluckily that it still the same. i think my Power Query cannot detect Value on SFDC Tab, although Webview tab was available to view.

besides, the Table View was not available:

[Kimot0407]

Hi @Anonymous , i got the solution that i need connect the SFDC Report ( From online Services) and Connect Report or Objects to link the total source data of SFDC to Excel. That would be displayed all Reports (Available on My company SFDC domain) so i need search on Navigator search to find out correct Report i needed to run. it worked.

Direction from Web Link of Report wasn't as i made the question, i still done know the reason - thank for your support

[Anonymous]

Hi @Kimot0407 

You can try to clear the permission in Dats source settings, then reconnect the data source.

Best Regards!

Yolo Zhu

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