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.
Hi there,
BACKGROUND: I'm building a set of reports that all acquire data via an anonymous web API - API calls to collect data from one system the company uses.
I've set up two simple dataflows - basically both contains a one row one column table with the username in one, the password in the other. I did this so that should this ever change in future I could easily make the change once at the dataflow level and that would update credentials for each of my reports.
My problem is that even though I can bring these dataflows in successfully each time for each report, they come in as a table with a single entry. How can I use that single attribute as part of the login credentials in the API call, and that will also work in the Service when I publish the report? I don't know how to convert the single value in my one row, one column dataflows into a variable so I can use it in the API call.
Any help really appreciated. Is this a sensible approach in general? Is there a better way of managing this that I haven't thought about?
We have Pro user license here.
Tables have rows and columns. Rows are addressed by the row number, columns are addressed by the column name.
To get the single cell value (assuming the column name is "Column1" you would say
Source{0}[Column1]
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.