Is it possible to create views (similar to SQL views) in Power BI

[jasonyeung87]

Hi,

I was wondering is it possible to create something similar to SQL views in Power BI? For example, in SQL I have a table with 5 fields named "testtable":

I can create a view with the following SQL Statement:

CREATE VIEW [dbo].[testview]
AS
SELECT field2, field3
FROM dbo.testtable
GO

this view contains 2 of the fields from the original table. I could also add additional tables (if related) within this view.

Jason

[ASHIS-KUMAR]

Ah...
You are talking about Merge Query.

You can do that & combine two tables, select the desired columns. Its kind of a view.

[djurecicK2]

Hi @jasonyeung87 ,

 For what you are trying to do, it seems like append is a good solution.

Also, if you have a sql data source, you could use a view or write a query with the join and import that data into the report.

[jasonyeung87]

Hi @djurecicK2 ,

What I have are a couple of tables from different data sources. these tables store time tracking hours for 2 different systems. I want to combine them into 1 table and have Power BI generate visualizations based on this table.

In SQL, I could do this in a few ways (e.g. create a view, which joins these tables, create a SELECT .. UNION statement). In Power BI desktop, it looks like I could create a new table and append the various tables to it. I was trying to determine if there's a different way besides appending tables.

Jason

[djurecicK2]

Hi @jasonyeung87 ,

 Would you mind giving some information around what you are trying to do with the view? You can't create a view per se, but I would guess that there is a way to solve the issue in Power BI without creating one.