Power BI report not refreshing after Sweden Upgrade

Modified on Thu, 22 Feb at 12:43 AM

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 are applicable.


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. 
  3. Review and compare the pbix file with the same report on the Power BI website 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. 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article