Refresh your Power BI dataset using Microsoft Flow
Today, we are making scheduling of refreshes much more flexible to improve how Power BI works in processes like the ones described above. Specifically, we have added a new Refresh a dataset&#…
Automatically rotate through Power BI report pages on your browser
This question comes up pretty regularly, I have a big screen in my hallway and I want to show some Power BI reports that rotate. Now there is some build...
Power BIte: Sharing and reuse with dataflows and datasets
Last week I kicked off the new BI Polar YouTube channel with a video and blog post comparing and contrasting Power BI dataflows and datasets. In the days that followed, I continued to hear questions t…
From Forms to PowerBI and the glue is Microsoft Flow
Intro In the coming days I have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putti…
The new workspaces in Power BI Service contain 4 roles: Admin, Member, Contributor, and Viewer. Simplifying the table below, users or groups granted an Admin role have permissions to make any type of …
Keep your Power BI SharePoint reports current with Microsoft Flow
Power BI is without question the best way to report on data in SharePoint lists. The query tools available in Power Query make working with SharePoint data relatively painless, an the cached datase…
I received today what is becoming a common question: I have a customer who is using dataflows to populate a 255M row fact table, refreshing the last 2 months of data (which is working) but experiencin…
Move dataflows across workspaces with the Power BI REST API
Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but a…
Announcing new contact lists for reports and dashboards in the Power BI service
The new contact list for reports and dashboards makes it easy to support end users by providing a contact list that includes multiple users or even groups in the Power BI service. When used with the New Look for the Power BI service, end users can quickly find and contact someone to make timely data driven decisions. Read on to learn more about the new contact list capability.
I do a lot that’s not related to dataflows. In fact, dataflows take up a surprisingly small part of my day, if your insight into my calendar came solely from this blog. Despite this, I like t…
This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head…
In a recent post I mentioned an approach for working around the import-only nature of Power BI dataflows as a data source in Power BI Desktop, and in an older post I shared information about the en…
Announcing Automated Machine learning in Power BI general availability
We’re happy to announce that Auto ML in Power BI is generally available in all public cloud regions where Power BI Premium and Embedded is available. Using Auto ML in Power BI, business analysts can build ML models to solve business problems that once required data scientists.
Overview of Available AI and ML capabilities in Power BI
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in…
Use microsoft flow and other options to refresh your power bi dataset
Adam looks at your refresh options for Power BI datasets. Including Microsoft Flow! https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
I use this diagram a lot[1]: This diagram neatly summarizes a canonical use case for Power BI dataflows, with source data being ingested and processed as part of an end-to-end BI application. It sh…
Power BIte: Creating dataflows with Power Query Online
This week’s Power BIte is the first in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by defini…
The Microsoft Power BI team have released a preview Data Lineage feature and I couldn’t be happier! The Power BI lineage view displays the lineage relationships between all the artifacts in a…
[Python] Using the Power BI API Without “Grant Permission” From Admin
La Data Web will show a bit of Python code in order to connect our work with the Power BI Service API. This post will help us to obtain the access token with pure urllib Python 3.7 code. What is special in this post is that we will use the Power BI API without the “grant permission” of the Azure/Off...
Choosing Azure Analysis Services for large datasets - SQLBI
I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations,
If you haven’t seen the news, the Power Platform has a new member of the family: Power Virtual Agents! Power Virtual Agents, provide exceptional support to customers and employees with AI-dri…