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.
Has anyone connected Power Bi to date in the Federal procurement system and generated dashboards. Just curious. FPDS allows extract to Excel and SOAP as well
Solved! Go to Solution.
In this scenario, since your data system can extract data into Excel, you can directly connect the Excel file and use it as data source in Power BI Desktop.
You can also use Web.Contents() function in Power Query to get data from web, web service. See: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Or you can convert the SOAP into REST:
Converting SOAP-based WCF Service to RESTful Design
Turn SOAP into REST
Then just "Get Data"-->"Other"-->"Web", it will parse the JSON into a table in Query Editor.
Regards,
In this scenario, since your data system can extract data into Excel, you can directly connect the Excel file and use it as data source in Power BI Desktop.
You can also use Web.Contents() function in Power Query to get data from web, web service. See: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Or you can convert the SOAP into REST:
Converting SOAP-based WCF Service to RESTful Design
Turn SOAP into REST
Then just "Get Data"-->"Other"-->"Web", it will parse the JSON into a table in Query Editor.
Regards,
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.