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.
Having trouble importing from two different API's. The first is OECD.org, the second is stlousifed.org. I am able to successfully import data in tables. The problem I am having is that values coming from the API's for percentages are imported as "text" by Power Bi - Power Query Editor.
For example 4.2 imports as text. The values need to be stored as 4.2%. The problem I am having is trying to transform them. If I select Transform - Data Type - Percentage Power Query Editor and Power Bi convert 4.2 (text) to 420.00%, which is not the correct value. As a workaround, I changed the [Value] type Text to Decimal, then I created a third calculated column called Percent = DIVIDE([Value],100) and then I Transform it to %. For a short term fix, this works kinda. Long term, as I intend to connect to numerous API's that provide the same values it will make the import tedious, not to mention storing extra unnecessary columns.
Any suggestions on how to resolve this using Advanced Editor functions that do not include creating calculated columns would be much appreciated. Below is some example date. Note: Each table to the left, save the "Formulas", one is an API call. Every one of them has a percentage number is stored as "text" during import.
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.