Power BI Dataflow

[Zuah04881]

Hi there,

My company is already adopting a centralised operational Dataset ( star schema approach) allowing users across department to build a Power BI report on top of the dataset.

Having said that , the operational dataset is not fully matured yet and the team is working on getting the data from different departments.

One of the request received from business is to use a date dimension table from the operational dataset and bring it into their model rather than creating one.

What would be a feasible solution - create a dataflow to bring date dimension table or ask them to connect to the ops dataset and use already existed date table, but then this will bring out unnecessary table into their table.

[v-tangjie-msft · Accepted solution]

Hi @Zuah04881 ,

To avoid bringing unnecessary tables into their tables, you can create reports that use OLS

The color saturation option is no longer supported for real-time tiles. If you attempt to add the saturation, you'll be met with an error. The option should be left empty and the visual will work correctly.

Object-level security (OLS) enables model authors to secure specific tables or columns from report viewers. For viewers that don’t have the required permission, it's as if the secured tables or columns don't exist.

You can view the following documentation to create a report that uses OLS

Object-level security (OLS) with Power BI - Power BI | Microsoft Learn

To create a dataflow, launch the Power BI service in a browser then select a workspace (dataflows are not available in my-workspace in the Power BI service) from the nav pane on the left, as shown in the following screen. You can also create a new workspace in which to create your new dataflow.

Creating date dimensions in a data flow is a best practice that you can refer to

Creating a dataflow - Power BI | Microsoft Learn

Solved: Re: date dimension best practice - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.