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:
No comments:
Post a Comment