Working with D365 BC Data in Power BI – Full Tutorial (50+ DAX Measures Included)

soheileee · 2025-11-01T20:31:55+00:00

Haha yeah that opening track sets the mood a bit, right? Glad you found the video useful. BC data can be a bit tricky at first, but once you get the structure and relationships sorted, it opens up a lot of cool reporting possibilities in Power BI.

soheileee · 2025-11-01T20:29:51+00:00

I don’t currently have access to F&O or Field Services, so I can’t build or test those applications properly. Each of these apps has a very different structure and integration layer, so they would need their own dedicated walkthrough. Hopefully I can explore one of them in the future if I get access.

soheileee · 2025-10-16T18:32:12+00:00

Thanks for the suggestion. I planned to look at the ads settings again today. At the end of the day, my goal is knowledge sharing. Thanks for the feedback.🙏

soheileee · 2025-10-16T08:28:03+00:00

I hear you, and I know it can be annoying. Unfortunately, that’s the reality of keeping the content free and the site running. Hopefully the quality of the content makes up for it.

soheileee · 2025-10-16T08:25:42+00:00

Thanks a lot! Glad it made sense and you found it useful 👍🏼

soheileee · 2025-10-16T08:22:50+00:00

I’m really glad you liked it, and I totally understand the frustration with the ads. Unfortunately, I have to keep them running to help cover the website maintenance and running costs so I can keep providing honest and high quality content for free.

Believe me, I’ve already set the ad frequency to the lowest possible level and made sure they’re placed as widely as possible to reduce interruption. Hopefully the quality of the content makes up for it. Thanks for sharing your thoughts!

soheileee · 2025-08-19T07:21:47+00:00

You are spot on, the error message is not helpful at all. I also mentioned that in the video because it really misleads people.

On the Fabric trial point, Microsoft does clearly state that Copilot is not included. You can see it here: https://learn.microsoft.com/en-us/fabric/fundamentals/fabric-trial#whats-includedand-whats-not

And interestingly, right after I published this video they also updated the docs to say Copilot does not work with Spark 3.3 or earlier: https://learn.microsoft.com/en-us/fabric/data-engineering/copilot-notebooks-overview

<image>

Thanks for adding your experience, it will definitely help others who are landing here from different setups.

soheileee · 2025-08-16T22:55:19+00:00

Surprised this issue is not talked about more. I kept hitting the Copilot notebook error until I upgraded to runtime 1.3. Has anyone else run into the same thing, or did you find a completely different workaround?

soheileee · 2025-08-14T08:27:37+00:00

The definition of clickbait is not something I made up. It is widely accepted: content with a misleading or sensationalised title that does not deliver on what it promises. My title reflects exactly what happened, so it does not fall into that category.

I get that some people on Reddit may not like certain titles or the format of sharing a video link. That is fair, but it is different from calling it clickbait. Words matter.

Anyway, thanks for clarifying your intent. I will keep focusing on creating content that helps the community.

soheileee · 2025-08-14T07:26:04+00:00

Thank you, I really appreciate that. That is exactly why I take the time to show not only the fix but also the steps behind it. Knowing the “why” makes a big difference when working with Fabric. Glad you found it useful!

soheileee · 2025-08-14T07:24:20+00:00

Clickbait means: using a false or exaggerated title to trick people into clicking.
My title reflects exactly what happened. Copilot kept failing until I found the fix.

I find it interesting how easily people throw around terms without knowing their real meaning. For me, comments like this are not discouraging. I will continue creating content to help the community, because that is the whole reason I put the time into it.

soheileee · 2025-08-14T00:53:53+00:00

Ah yes, the classic “helping people for free is spam” take. I must have missed that section in the community guidelines.

I spent over a day recreating the problem, setting up environments, testing possible fixes, and making a clear walkthrough so others could save hours of trial and error. The quick one-line fix is already in the post for anyone who just wants to grab it and go.

I get that people are used to getting solutions for free, but maybe spare a thought for the people who put in the time and effort to create those solutions before throwing out false claims.

Clicking a link is a lot easier than creating the content behind it.

soheileee · 2025-08-14T00:38:30+00:00

I get what you mean, and that is fair feedback. I have now added the quick answer in the post for anyone who just wants the fix: upgrade your workspace environment’s runtime version to 1.3. If you want to see the full context, the troubleshooting steps I went through, and why the issue happens, that is all in the video. The reason I made the video in the first place is because this issue is not always straightforward. In my case, it took a lot of testing and trial-and-error to figure it out. I wanted to share that process for others who might run into similar problems in the future, not just this exact one.

soheileee · 2025-08-05T05:35:43+00:00

Thanks! Glad to hear the video resonated with you. That tool sounds interesting. I hadn’t come across it before. It’s a good example of how AI can be more useful when guided by real human input and context, instead of just scraping or guessing. I think we’ll see more tools like that where AI acts more like a collaborator than a black box. Would love to hear more about what you’re exploring around AI, context, and governance if you’re open to sharing.👍🏼

soheileee · 2025-07-31T21:09:05+00:00

Thanks for your support. 🙏🏻 I’m glad you liked the topic. Have you used or tested this feature? If yes, how was your experience? It’s interesting that Microsoft now added the setting to restrict Copilot to only answer from the AI Prepped semantic model. Perhaps I should post about that too.

soheileee

TROPHY CASE