Skip to end of metadata
Go to start of metadata

Power BI report not refreshing after Sweden Upgrade. Not able to see the updated values in any of the visuals. Dataset tab shows the warning icon and displays 'Something went wrong' error message below 

Due to a change to data type on one of the columns used in the Datasets for LM-Power BI reports, the reports need to be republished to rectify this error. If your DB is hosted by LawMaster, please raise a helpdesk request. If you have an on-prem Power BI server, then the below steps are applicable.

Step-by-step guide

  1. Navigate to C:\\ PowerBI\DataModels. Or navigate to the folder where the DataModels are stored. These are usually .pbix files and 8 in numbers
  2. Open Pbix file in Power BI desktop. Review and compare the pbix file with the same report on the Power BI website
  3. If both are same and no changes to the visuals or filters,
    In Power BI
    1. Check the Data source parameters by clicking on "Edit Queries → Data Source Settings". Make sure this is pointing to 'LawMaster Production' database
    2. Click on the Refresh Button
    3. Click on the Publish Button
    4. When prompted, select to over-write the report on the corresponding workspace
  4. If there is a modification to the report on Power BI website, 
    In Power BI
    1. Click on the File button
    2. Download report (.pbix copy)
    3. Use the downloaded .pbix, and open in Power BI dektop
    4. Check the Data source parameters by clicking on "Edit Queries → Data Source Settings". Make sure this is pointing to 'LawMaster Production' database, if you are publishing to "Production Workspace", or "LawMaster Training", if you are publishing to "Training Workspace"
    5. Click on the Refresh Button
    6. Click on the Publish Button
    7. When prompted, select to over-write the report on the corresponding workspace

Repeat the above operation for all the reports prefixed with LM-"XXXXXXXXXXXXXXX". 

Login to https://app.powerbi.com/

Workspace → LawMaster XXXXXXX → Datasets. Hit the refresh button associated with each of the Datasets. The Warning icon associated within should disappear.

There is no content with the specified labels