Maintain the data format from power bi datset

[gavin007]

Hi, I use Powerbi dataset to build my new report, for some reason. when I change certain data format in the Powerbi dataset and it doesn't flow through to the new report. That is quite inconvenient as it have a lot a new data every now and then and it is kind of double maintaining the data format in both reports.

Is that a option to allow same data format flow through to new report via direct query?

[v-xulin-mstf]

Hi @gavin007,

Since this connection is a live connection, left-navigation and modeling are disabled.

You can only connect to one dataset in each report.

This behavior is similar to the behavior when connected to SQL Server Analysis Services.

However, the following article describes how a new feature in Power BI now makes this possible:

see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Best Regards,
Link

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

[gavin007]

I follow the link and it says "Format strings on columns and measures from a remote source are not imported to the composite model". 

So I am wandering if this is in future development pipeline?

[v-xulin-mstf · Accepted solution]

Hi @gavin007,

Yeah, connecting to the power bi dataset via Directquery mode is a preview feature and we can expect more refinements.

You can also summit a idea here.

Best Regards,
Link

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