Forum Discussion
Date Field Formatting changes after publishing it to PBI Service and connecting as PBI Dataset
Thanks Anonymous . I've reported it as an issue (see link below) and we can take it from there.
Hi vitorborges, as an initial check, could you verify what Power BI version you are using? Also, could you confirm whether you are simply using a "live connection" (connected only to a single Power BI dataset in your downstream report) or the "DirectQuery for datasets and Azure Analysis Services" feature?
I recall that in early releases of the DQ for datasets feature, formatting was not persisted to the downstream reports.
https://community.powerbi.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/1760255
Thanks for your prompt reponse Anonymous
I'm using PowerBI Version: 2.99.621.0 64-bit (November 2021) and am using "live connection", i.e. connected to a single Power BI dataset.
I came across some of jeroenterheerdt posts in my research that mentioned limitations in the feature, but the link quoted by him didn't work, so I was unsure whether the issue had been addressed or not.
Should we expect a fix sometime in 2022?
Thanks again.
- jeroenterheerdt
Microsoft Employee
Does this link work for you? https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services
