The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good afternoon everyone. I am doing some work for a company who wanted me to design a pagained report--in doing so, they have put their data into dataflows and brought them into a data mart in the service--They wanted me to design the power bi report and measures in the service from the direct query and then create the paginated report-I am used to using the import mode on the desktop, so needless to say, this has been a challenge. I did have everything going forward until recently. Fast Forward to the other day--IT did some changes to the data flows and rebuilt the data mart--in doing so, ALL my measures have disappeared. The measures weren't in what IT was fixing, so I am not sure why they disappered. My date table is also broke, but I can fix that.
I had all my measures in a table. The table is still there, but all of my measures are gone. I had well over 100 of them. I don't know of any place in the service that creates "versions" like the desktop, so I am at a loss of how to fix this except to recreate them. I do have the power bi file in the service where the visuals are now broken, so I can look at those and try to recreate the measures from that. Does anyone have another idea? I know this is a holiday weekend, but if anyone has a fix for this or has experienced it and knows how to prevent it from happening again, I would greatly appreciate it. #directquery, #powerbiservice, #measures
I also would like to have help on it. I noticed that depending on the connexion used, I have or not the measures from datamart.
Having over 100 measures is already a red flag.
You have to remember that whenever you change the structure of your data source query and the final result differs from the previous version on a meta data level (say, you removed a column) this will have near-catastrophic impact on your measures, groups, hierarchies and sort orders. At the very minimum you need to make a backup of your prior version before attempting these changes.
Restore the backup if you have one, otherwise take this as a hard lesson learned.