Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Analysis Services Refresh Issues

Hello everyone. I have a question regarding dashboards using Analysis Services connection. I have a connection to a cube, which was then used to build a dashboard. Works great, until I upgrade to new version. It refreshes, but weird things happen such as fields I selected for certain visuals are not what they actually are. I don't know how to resolve this. Has anyone experienced this before and if so, what steps weret taken to resolve the issue. I don't want to be limited on staying with only one version. I would like to conitinue upgrading as new features roll out. 

 

Any help would be appreciated, 

Thanks! 

  • Anonymous's avatar
    Anonymous
    9 years ago

    The problem was that during my dashboard creation process, I had an Applied Step in my cube to remove a column that I didn't need. Since I had multiple data sources, sql tables and a cube, I had to use the import option. When refreshing after upgrade, that step to remove the column caused the failure. I removed the step, and when straight to the Added Items for the cube source, and filtered the columns that I didn't need there. Works perfectly. Seems like a pretty unique circumstance but, maybe someone might find my error fix useful!

     

     :smileyhappy:

6 Replies

  • Sunkari's avatar
    Sunkari
    Responsive Resident

    Is upgrade of Power BI Desktop or analysis service model?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Power BI Desktop.

       

      The dashboard works fine on the March version of Power BI. Fails on the April and May versions. 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Nevermind, fixed it!