power bi report in business central | integrating power bi report in business central | part -1

Hi Viewers,
power bi report in business central | integrating power bi report in business central | part -1
This channel is dedicated to research aspirants and all who wish to learn technologies with easy examples and exercises. I will be uploading at least three videos every week. You can leave the expected topics which you wish to know in the comment.
Checkout your favorite playlist
==================================================================================
Important tutorials and videos (Playlist) that you should not miss
==================================================================================
1. Research: • PhD Course details, Ph...
2. SCI/Scopus/Annexure-I/WoS/UGC care indexed journals
• SCI, Scopus, Annexure-...
3. Weka Tutorial:
• Weka Tutorial
4. Tableau Prep Builder: • What is Tableau Prep |...
5. ETL Data Integration: Talend:
• What is ETL? well Expl...
6. AL Programming - Microsoft Dynamics 365 Business Central (AL Programming): • AL Programming for abs...
7. Web Designing for Kids:
• Simple sign-in form in...
8. Tableau Desktop: • Learn Tableau Basic Ca...
9. Python Interview Questions: • What is Negative index...
10. GraphPad Prism Statistical Tool: • Introduction to GraphP...
11. R and Rattle GUI for statistics and Research: • Introduction to R and ...
12. Minitab Statistical Tool: • How to download, insta...
13. Online teaching tool for teachers, professors and online mentors: • Best online Whiteboard...
14. Skill-up yourself: • How to become a google...
======================================================================
Social media:
Blog: draft.blogger....
GitHub: github.com/Gom...
LinkedIn profile: / gomathisri
Instagram profile: @goms_tech_talks
Facebook profile: / goms.techtalks
Website: sites.google.c...
======================================================================
Happy learning

[@indranijayakody3381]

Good video for power BI integration

[@gomstechtalks]

Thank you.

[@simongiang]

I didn't see the option "Set up reporting data for your own reports" in the Assisted Setup list I am using BC 210.

[@priyobrotoghoroi5084]

Thank you, Can you please suggest a video/web address to learn power Bi for business central. from beginner to advance level.

[@gomstechtalks]

Sure, let me check and get back to you

[@priyobrotoghoroi5084]

@@gomstechtalks @Reminder

[@gomstechtalks]

Can you please tell what are the topics you are expecting from beginner to advanced level?

[@plshakya]

Thank you. It's very helpful

[@gomstechtalks]

Glad it was helpful!

[@lamakhaled1904]

Hi when I load the page from the web service at Power bi this error appears: SalesInvoiceHeaderApi Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The current operation was cancelled because another operation in the transaction failed. '. How I can solve that, please?!!

[@gomstechtalks]

Here are a few steps you can try to resolve this issue: Check API Permissions: Ensure that the API permissions for Dynamics 365 Business Central are correctly set and that your service account has the necessary access rights. Verify Network Stability: Sometimes, intermittent network issues can cause this type of error. Ensure that your network connection is stable and reliable. Refresh Credentials: In Power BI, try refreshing the credentials used for the data source connection. This can sometimes resolve issues related to session timeouts or authentication errors. Increase Timeout Settings: Consider increasing the timeout settings in Power BI for the specific data source, which might help if the data volume is large or the network is slow.

[@geetapundir3148]

Your videos are great.Do you give one to one training?

[@gomstechtalks]

Thank you, Geeta. Currently, I am not giving one-to-one training due to my bus schedules.

[@ishusearshtak9464]

Hello maam , I am uanble to see "Set uo Reporting Date for your own reports" option in assisted setup The BC i am using is BC220. Thanking you in anticipation

[@gomstechtalks]

Hi, Please check whether you have that permission.

[@johnonyoutube6080]

@@gomstechtalks what permission do we need to check, I have asked our support partner and they are wondering if the "Set up Reporting Date for your own reports" option is an extension?

[@johnonyoutube6080]

Has anyone been able to find this option? google shows only one reference to it on the internet.

[@ShabhareshM-hh7ih]

Hello Mam, The option "Set up reporting data for your own reports" is not available. This option does not appear in the assisted setup menu. Please help me to resolve this.

[@gomstechtalks]

Hi, please check whether the Power BI chart is enabled by your admin.

[@suganyam3107]

Hi, The option to select "Set up reporting data for your own reports" is not available for me either. This option does not appear in the assisted setup menu. Please help me to resolve this.

[@gomstechtalks]

Please check, whether you have the access to the reports. Check with your admin.

[@danielibrahim891]

Hi, do you need a business central licence to consume webservices/APIs in BC?

[@gomstechtalks]

Yes, in order to consume web services API in Business Central (BC), you do require a Business Central license. The license grants you access to the full functionality of BC, including the ability to use web services API to integrate and interact with external systems. Without a valid license, you may not have the necessary permissions and entitlements to utilize the web services API features. It's important to ensure you have the appropriate licensing in place to comply with the terms and conditions set by Microsoft for using Business Central and its associated services.

[@user-cm2hw6pv2x]

I couldn't see the option "Set up reporting data for your own reports" in the BC

[@gomstechtalks]

Please tell me what you are trying to do? I can't try to solve it unless I know what you are trying to do

[@user-cm2hw6pv2x]

@@gomstechtalks i couln't get all tables to power bi from business central...i was trying

[@mathew6057]

The option to select "Set up reporting data for your own reports" is not available for me either. This option does not appear in the assisted setup menu

[@yathishjr617]

Akka, Can I know how to automate Pull request, Any idea on this? Please reply...

[@gomstechtalks]

Sure, please tell me the scenario or example so that I can check for the possibilities

[@yathishjr617]

@@gomstechtalks ​ @goms tech talks STEP1 - Selecting source control. STEP2 - Creating new branch. STEP3 - Creating new branch from Origin/Dev. Branch name should be unique to avoid failures. STEP4 - Selecting source branch Origin/Dev. STEP5 - Staging the files which we have made changes. It can be achieved by getting the value of the documentation line tag (Eg. ES123YJR) using that we can get files.

[@yathishjr617]

STEP6 - Type the message. It can be achieved using the same documentation line tag (Eg.ES123YJR 20221215) but it should also have the date with it so it can bring that exact line to the message. STEP7 - Commit the changes by clicking on commit. Check whether our files are staged. STEP8 - Publish the branch by clicking on publish. STEP9 - Then we should go to browser and open repo of the respective customer we are working and there will be a pop-up button like create a pull request click on create pull request button. STEP10 - change the branch from to Dev. Check whether tittle and description matches. If it doesn’t match copy from description and paste it in title. STEP11 - Add reviewers. After adding reviewers check whether work item is linked or not. If it is not linked link it. STEP12 - Click on create to complete creating Pull request. Check whether there are any merge conflicts.

[@gomstechtalks]

Haven't tried this before. I will try and let you know

[@suriyaprakashs5196]

@@gomstechtalks @Yathish Jr it will be helpful for me as well.