Forum Discussion

alex's avatar
alex
Helper I
7 years ago

Can PowerQuery accept a csv file from a web service (specifically Tableau)?

Hello,   We have a Tableau server which can provide data via a CSV file. (If you are in a browser, you goto http://my.tableau.server.com/site/MyReport.CSV and then the browser downloads a CSV file...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Try using a CSV data source and put in the web address.

alex's avatar
alex
Helper I
7 years ago

I get this...which is the same DOCTYPE HTML page...it's not actually accepting the CSV....

 

(whoops:  reuploaded screenshot...)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    alex ,

    Does Tableau provide Rest API  to access the CSV? You are able to connect to REST API in the web connector of Power BI Desktop.

    Regards,
    Lydia

    • alex's avatar
      alex
      Helper I
      7 years ago

      Hi Lydia,

      Do you mean New Source ->  Web?

      No, I get the same result.... (the Same <!DOCTYPE html> page)

      -Alex

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        alex ,

        Please contact tableau support to check if it provides rest api and what authentication method is used to access the rest api.

        Regards,
        Lydia