Re: Can PowerQuery accept a csv file from a web se...

alex · ‎02-12-2019

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 to your Downloads folder The Tableau server uses the windows credentials for authentication)

I'd love to import this data via PowerQuery. Is this possible and can you point me to how to start?

When I do this in power query:

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://my.tableau.server.com/#/site/MyReport.csv"))})
in
    Source

I get this:

<!DOCTYPE html><html xmlns:ng="" xmlns:tb=""><head ng-csp><meta charset="UTF-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=1024, maximum-scale=2"><meta name="format-detection" content="telephone=no"><meta name="vizportal-config" data-buildId="819vpf68wrqrryd7mv8zd7vi" data-staticAssetsUrlPrefix=""><link rel="stylesheet" type="text/css" href="vizportal.css?819vpf68wrqrryd7mv8zd7vi"><script src="/javascripts/api/tableau-2.2.1.min.js?819vpf68wrqrryd7mv8zd7vi"></script><script src="vizportalMinLibs.js?819vpf68wrqrryd7mv8zd7vi"></script><script src="vizportal.min.js?819vpf68wrqrryd7mv8zd7vi"></script></head><body class="tb-body"><div ng-app="VizPortalRun" id="ng-app" tb-window-resize class="tb-app"><div ui-view="" class="tb-app-inner"></div><tb:react-toaster></tb:react-toaster><script type="text/ng-template" id="inline_stackedElement.html"><div tb-window-resize tb-left="left" tb-top="top" tb-right="right" tb-bottom="bottom" tb-visible="visible" class="tb-absolute"></div></script><tb:stacked-elements></tb:stacked-elements></div></body></html>

Many Thanks,

Alex

Greg_Deckler · ‎02-12-2019

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

alex · ‎02-12-2019

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

(whoops: reuploaded screenshot...)

v-yuezhe-msft · ‎02-15-2019

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

alex · ‎02-18-2019

Hi Lydia,

Do you mean New Source -> Web?

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

-Alex

v-yuezhe-msft · ‎02-21-2019

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024