Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Try using a CSV data source and put in the web address.
I get this...which is the same DOCTYPE HTML page...it's not actually accepting the CSV....
(whoops: reuploaded screenshot...)
@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
Hi Lydia,
Do you mean New Source -> Web?
No, I get the same result.... (the Same <!DOCTYPE html> page)
-Alex
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |