Tag: Power BI

Power BI , Power Automate— auto refresh dataset after dataflow
Power BI , Power Automate— auto refresh dataset after dataflow
Blog Posts

Today I want to show you how to implement an auto dataset refresh after a dataflow is refreshed. On order to this, we use Power Automate. Let’s say that after an Iowa_Liquor_Sales dataflow is refreshed we want to refresh an Iowa_Liquor_Sales dataset automatically. So, create a New flow and choose an Automated cloud flow option. Choose a When dataflow refresh completes trigger. After creating the trigger, you are… READ MORE

Power BI – Scheduled Refresh for your Dataflow
Power BI – Scheduled Refresh for your Dataflow
Blog Posts

Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE

Organize and Monitor the Power BI Scheduled Refreshes
Organize and Monitor the Power BI Scheduled Refreshes
Blog Posts

With Power BI you can set up a scheduled refresh of any dataset which have an accessible data source. But you must be aware of, how many refreshes are at the same time. With every particular capacity you have only limited parallel refreshing resources. So, you can only refresh one dataset at the same time… READ MORE

Power Pivot and Power BI
Power Pivot and Power BI
Ebooks

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE

Integrate Power BI Reports in SharePoint Online
Integrate Power BI Reports in SharePoint Online
Blog Posts

We have been waiting for this for soooo long! I’m very happy to announce the availability of the Power BI report web part for SharePoint Online! The new web part Microsoft is releasing today enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required! In the sample below I… READ MORE

Latest on the ESPC Community
Latest on the ESPC Community
Blog Posts

Grow and enhance your skills with the European SharePoint, Office 365 & Azure Community. Joining the ESPC Community, gives you access to the online resource centre at sharepointeurope.com, providing the best, free content on SharePoint, Azure and Office 365. Topics covered include Microsoft Teams, SharePoint, SharePoint Framework, Office 365 Groups, OneDrive, PowerApps & Flow, Security,… READ MORE

Beginning Power BI - Data Munging with Power Query
Beginning Power BI – Data Munging with Power Query
Ebooks

Analyse your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualisations and share them with your colleagues. This excerpt ‘Data Munging with Power Query’ from the book Beginning Power BI by Dan Clark… READ MORE