Refresh the hidden model of a database structure on the PowerBI Portal, everytime a dataset is republished. Recently we encountered an issue where a table and some fields had been removed from a source database. I have a couple of PowerBI datasets which connect to this SQL Database. I do this to make it easy for users to find information and fields if they use the datasets. I have been told by PowerBI support that when you submit a dataset, a separate background thread creates a model of the database for reference. The assumption is that you would only have one Dataset referencing the database. The impact for me was that to get everything working again, I had to delete all datasets, reports and dashboards that referenced that database, and then republish them, reset the credentials, and rebuild all the dashboards. This will be a maintenance nightmare in the future. It was suggested that we either build one really big model or dont delete anything from the database. Neither is a good option. I personally would rather be notified which datasets are no longer correct, so I can fix them in PowerBI Desktop, and then republish them. Will save me a huge amount of effort.
frithjof_v
on:
Fabric Deployment Pipeline - Trigger Fabric Data F...
miguel
on:
Jestor .mez connector not recognized in Power BI S...
on:
allow the use of Python scripts with the enterpris...
on:
Enable/Disable RLS Roles in PowerBI & avoid deleti...
on:
LAST_DAY() function
on:
Button Slicer width and Height should not changed