Roamler
Microsoft Power BI is an excellent data visualization and business intelligence tool that can be used to turn large datasets into insightful reports and dashboards. It is a cloud-based service that allows users to connect with a wide range of data sources, including cloud-based and on-premises sources. In this article, we will focus on connecting to the Roamler data source from inside Power BI using Power Query M Language code.
What is Roamler?
Roamler is a mobile crowdsourcing platform that enables businesses to collect data, insights, and feedback from customers in real-time. It is used by companies in various industries, including retail, hospitality, and logistics, to improve their operations, products, and services. Roamler‘s platform provides data on consumer preferences, shopping behavior, product availability, and more.
Connecting to Roamler Data Source
Before connecting to the Roamler data source, you need to have a Roamler account and obtain an API key. The API key is required to access the data source. Once you have an API key, follow these steps to connect to the Roamler data source from inside Power BI:
1. Open Power BI and click on the “Get Data” option on the Home tab.
2. Select “Web” from the list of data sources and click on “Connect”.
3. In the “From Web” dialog box, enter the URL of the Roamler API, which is “https://api.Roamler.com/v2/”. Click on “OK”.
4. In the “Navigator” dialog box, you will see a list of tables available from the Roamler API. Select the table you want to use and click on “Load”.
5. Power Query will load the data from the selected table and display it in the Power Query Editor.
Power Query M Language Code
Power Query M Language is a functional programming language used by Power BI to transform and manipulate data. It is used to create queries that extract, transform, and load data from various sources. To connect to the Roamler data source, you can use the following M Language code:
let
apiKey = “YOUR_API_KEY”,
apiUrl = “https://api.Roamler.com/v2/”,
tableName = “TABLE_NAME”,
source = Json.Document(Web.Contents(apiUrl & tableName & “?apikey=” & apiKey)),
#”Converted to Table” = Record.ToTable(source),
#”Expanded Value” = Table.ExpandRecordColumn(#”Converted to Table”, “Value”, {“COLUMN_1”, “COLUMN_2”, “COLUMN_3”}, {“Value.COLUMN_1”, “Value.COLUMN_2”, “Value.COLUMN_3”})
in
#”Expanded Value”
In the code, replace “YOUR_API_KEY” with your Roamler API key, “TABLE_NAME” with the name of the table you want to extract data from, and “COLUMN_1”, “COLUMN_2”, “COLUMN_3” with the names of the columns you want to include in your query.
The code uses the Web.Contents function to send a request to the Roamler API using the API key and table name specified. It then converts the response into a record format using the Json.Document function. The data is then converted to a table using the Record.ToTable function and expanded using the Table.ExpandRecordColumn function to include the selected columns.
Conclusion
In conclusion, Power Query M Language code can be used to connect to the Roamler data source from inside Power BI. This allows businesses to analyze and visualize Roamler data alongside other data sources. By following the steps outlined in this article, you can easily connect to the Roamler data source and start extracting insights from your data.
