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 “”. 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:


apiKey = “YOUR_API_KEY”,

apiUrl = “”,

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”})


#”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.


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.

Power BI Training Courses by G Com Solutions (0800 998 9248)

Contact Us


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)

    Similar Posts