Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
I successfully posted a 3 page report from Power BI desktop to PBI service online. The reports is based on data from the same file in Excel with different tabs.
Please see the 3 pages that exists in PBI desktop. - Income statement, Balance sheet & Cashflow including the success posting message from Power BI
The problem I appear to be facing now is when I view the same reports in Power BI online service, Not all the charts/graphs are showing on the reports. Please can you let me know what I am doing wrong and why not all the data is being shown. Please see the reports below on Power BI Service
Many thanks
Solved! Go to Solution.
@atin
I noticed that Year filter is placed on both Visual and Page Level. I cleared the Page Level filter and it works in service.
You keep the filters either on Visual or Page.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@atin ,
Is there any low level seurity in your report? What kind of dax calculations are used for these visuals that do not display data?
Could you compare data used in visuals that work ok vs visuals that return error? There must be some column format (like date column) that is not the same between your pc settings and Power BI service settings.
@nandic - Many thanks for your response - I am not aware of any low level security as I am using a demo dataset.
Following on from my earlier comments - all 3 reports ie Income statement, Cash flow and Balance sheet are from the same dataset.
I will go back and recheck them all once again, however it is very strange that whilst the Income statement is ok - the 2 other reports are not, given that they share the same dataset.
@atin
Can you share your PBIX file and source data to check further?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Many thanks @Fowmy for your assistance
please see drop box link to excel file - https://www.dropbox.com/t/qpz0w37ntYJwIUdo
PBIX file link https://www.dropbox.com/t/Sy3jUHWe28bu3aIl
Please let me know if you are not able to access.
@atin
I noticed that Year filter is placed on both Visual and Page Level. I cleared the Page Level filter and it works in service.
You keep the filters either on Visual or Page.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@atin
You can delete the reports and datasets then republish.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Many thanks for your response @Fowmy - I tried this twice and still got the same errors
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |