In Power BI, a Blank Query allows users to create a table or dataset manually using M code in the Power Query Editor — without needing
a connected data source.
Following are the Use Cases & Benefits of using the Blank Query:
-
Ideal for mock data creation, manual lookup tables, or custom calendars.
-
Great for demos, testing calculations, or building logic before data arrives.
-
Helps in creating quick what-if scenarios or manually entered mappings.
Following are the steps to create a report using the Blank Query:
-
Open Power BI → Go to Home > Get Data > Blank Query
-
In the Query Editor → Click on Advanced Editor & Paste the M code for your requirement.
-
We have created below code for World Clock to display current time for each continent (Clock):
-
Create the Report using the data provided by the query. Below is the sample report that we have created with the query:
