Hi All,
When it rains it pours :(
When the deadline is next day and when you are close to solution and suddenly your Visual studio file is frozen and then it does not open for hours....
Finally what worked is Import the model in Visual studio instead on opening the existing one
Puff!!
Hi All,
I have 20 Visual in a page and I could see that I was not able to delete few KPI in my page.
When I right click on that visual I could not find the delete option. I was able to find the "Focus Mode"
Resolution - Click on "Focus Mode".
2. Three dots would then appear.
3. Click on it and option to delete the page would come up
Hi All,
I duplicated one page and the for some reason I was not able to delete this page. I stayed with this issue for 2 to 3 months. Later I found the resolution for this.
Fix - Publish it to workspace
1. Pages would be hidden
2. Unhide Page
3. Make the contents of the page which you want to delete empty i,e remove all visuals from it
4. If you want to retain that page then dupliace that page and automatically the option to delete the current page comes up
5. Unhide required pages and then delete the not required Page.
Bingo! Issue is fixed :)
Hi All,
After I publish my Power BI report to workspace, in reading view I could not see the second page or remaining pages.
To enable this feature
Click on File > Settings
Hi All,
When you have a slicer in your dashboard that gets data from a calendar table saved in SSAS tabular model and then your requirement changes that the slicer should display max date as Yesterday's date
Apply the below DAX formula to your calendar and Bingo, issue is fixed !
=CALENDAR ("1/1/2015",TODAY() - 1)
Hi All,
I moved my Analysis tabular model cube to production and changed the settings in Power BI. No Visuals were working and all gave me same error Unexpected error. When I clicked on Copy message it told me a lot of DirectQuery features disabled.
I spent time in enabling these features but Alas ..this was not the fix.
The fix turned out to install the latest cumulative update for the SQL server version installed in production.
https://support.microsoft.com/en-us/help/2876882/kb2876882-fix-internal-error-an-unexpected-error-occurred-when-you-run
Enjoy deploying!!
Hi All,
I had a requirement where I have to introduce spaces between bar chart columns. Since this is not a default option present in power BI, I had to apply for workaround.
The steps in below link helped me achieve it
https://community.powerbi.com/t5/Desktop/Spacing-in-column-chart/m-p/423641#M194839
Enjoy!!
Hi All,
Follow the below steps to find the version details of SSAS Analysis server
SSMS: connect to your SSAS.
* Right-click Server
* Reports
* Standard Reports
* General
