Date Dimension is the most important dimension for a BI Reporting. We can create it in Multidimensional Cube or most of the times we can load it directly from our source database. But what to do if we don't have date dimension and want to create our own ? Check the steps below to create … Continue reading No Date Dimension !!! Create it directly inside Power BI Desktop
Explore your organization’s Financial Performance Connect to your Microsoft Dynamics AX/Operations financial data for access to insights about your organization’s financial performance. This content pack is designed specifically for CFOs by providing details on financial performance. The dashboard and reports are built on top of a fully featured model, so you can explore and analyze … Continue reading Microsoft Dynamics AX/Operations Financial Performance content pack
Lets Get Started !!! Create a dataset in Power BI Sign-in to Power BI Open the workspace where you would like to create a Power BI report. Select Create --> Streaming Dataset Select API In the New streaming dataset panel, enter the details like dataset name, conditions, date, temperature etc. that you would like to … Continue reading Microsoft Flow & Streaming Dataset in Power BI
Now analyze Power BI reports, slice & dice its data directly in Excel from Power BI workspace/groups !!!
Steps Go to Power BI App Registration Tool Select Sign in with your existing account Click Register App Copy the Client ID and Client Secret and save it. Open your Dynamics 365 for Operations application. Go to System administration --> Setup --> Power BI Copy the Client Id and Client secret and paste it in the … Continue reading Register Dynamics 365 for Operations for Power BI
Quick Insights is a feature of Power BI that helps to : Build a quick dashboard Give a quick idea about the data. Provides insights in case missed Generated interesting visualizations based on data available Let's Get Started !!! Go to PowerBI Open Left Navigation Pane --> Datasets Select your Dataset --> click (...) --> Quick … Continue reading Quick Insights Feature : Let Power BI create Insights for you!!!
Power BI reports can be used for reporting on Dynamics 365 for Operations. Power BI now can be embedded in Dynamics 365 for Operations !!! Users can pin following on the application's workspaces from Power BI reports and dashbaords : Power BI reports will all its pages. Tiles from Power BI dashboards How does Power … Continue reading Power BI Reports with Dynamics 365 for Operations