Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are connecting Power BI Desktop with our custom data source which implements Postgresql Protocol and gets connected with the PBI Postgresql Connector. W.R.T. to Power BI Reports reflecting the schema evaluation changes into custom data source tables, We have found that Power BI Desktop reflects the schema changes correctly (column addition) when schema change done at the source table, but PBI Service does not replicate same behaviour.
Also found this behaviour similar on the Native Postgresql database, on which the Custom Data Source Protocol is based of. Please see the below details.
While the same behaviour, we couldn’t get reflected on Power BI Service (maybe due to a session refresh? Not sure)
The only difference between Native Postgresql and our Custom Data Source is that Native Postgresql reflects schema changes in the same session (without closing the PBI desktop) while the our Custom Data source needs a new session to see the updated tables, if this details helps.
Could you please look into the Power BI Service area to have the same schema updates reflected there? Please let me know if you need more details.
Thanks,
Himanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.