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...
Need Help
  • 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:

Sunkari's avatar
Sunkari
Responsive Resident
9 years ago

Is upgrade of Power BI Desktop or analysis service model?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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
      9 years ago

      Nevermind, fixed it! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        Glad to hear the issue is solved, you can share solution here and mark it an answer, that way, other community members could benefit from your solution.

        Thanks,
        Lydia Zhang