Forum Discussion
Powerbi reports
I already developed report for report1 which is fetching data from multiple tab from single excel which was stored in SharePoint folder and so requirement is we have another SharePoint list which I have added into the same power bi to the above existing report so sharepoint list data is stored as table and visualization I'm trying to do for this SharePoint list dat so I create measure for status completed and open in the SharePoint list data in different report but I'm getting error fetching data for this visual. Kindly help.so I'm looking to get count from the report1 into this new report of my SharePoint list data report. So how do I fetch this count too
bzeeblitz , Not very clear. You should add the both share point data in one pbix file or Power BI report and use common dimensions to join these two data and analyze them together.
refer if needed
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
2 Replies
- amitchandak
Super User
bzeeblitz , Not very clear. You should add the both share point data in one pbix file or Power BI report and use common dimensions to join these two data and analyze them together.
refer if needed
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
- v-saisrao-msft
Community Support
Hi bzeeblitz,
I wanted to check if you had the opportunity to review the information provided by amitchandak. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.