Tag Archives: Dataset

Find all queries to Azure AS from a Power BI report or dataset

November 14, 2019 Self-Service BI

I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report and dataset in Power BI that generate each query.

To show you how this works. I captured the queries in AAS using Azure Log analytics as I described here.

I then make sure I add the column ” ApplicationContext_s” using the query below. This will give me the context the query was running under.

AzureDiagnostics | where OperationName == "QueryBegin" | project TimeGenerated, TextData_s, DatabaseName_s, ApplicationContext_s | where TimeGenerated > ago(2h)

Find all queries to Azure AS from a Power BI report or dataset

In this case it is the generated by the Power BI service and the column contains the DatasetId and ReportId as we know it in Power BI.

This is very useful if we want to figure out who is generating a particular load on the service.

But there is also another use of this, we can use the DatasetId or ReportId as filter to the query. This allows us to only see the data for the dataset or report we want.

AzureDiagnostics | where OperationName == "QueryBegin" | project TimeGenerated, TextData_s, DatabaseName_s, ApplicationContext_s | where TimeGenerated > ago(2h) | where ApplicationContext_s contains "b9d53eb4-01e7-4eb5-989b-a416769b9001"

A very useful addition to the logs that might come in handy when doing some debugging.

Let’s block ads! (Why?)

Kasper On BI

Refresh a Power BI dataset that feeds from SharePoint list automatically

October 30, 2019 Self-Service BI

The Power BI team recently shipped some cool new flow options and one of them is really cool. Many times I hear of reports and dataset that fully rely on SharePoint lists. These lists are used by business groups that don’t have the rights to spin up and Azure SQL database or just want to keep a simple list to store their dimensions. SharePoint lists are great for that.

The new flow option allows you to automatically update the dataset whenever a new item is added to the list, that is pretty cool.

Here is how it works. Start at your list in SharePoint and click automate and select create new flow:

Refresh a Power BI dataset that feeds from SharePoint list automatically

A new pane opens to the side, the flow we want is not part of the default list so we select “see your flows”

This opens flow where you can start a new automated flow which we need.

This opens a new flow, give it a name and choose “When an item is created” as trigger for the flow:

Nest pick the list you want to trigger on:

Then finally configure what happens when the trigger is fired. In this case we want to select “Refresh a dataset”.

Next you can select the dataset you want to refresh:

Now every time an item gets added to the SharePoint list the dataset gets updated with the new information. Very cool!

Let’s block ads! (Why?)

Kasper On BI

Refresh your Power BI dataset using Microsoft Flow

October 18, 2019 Self-Service BI

When speaking with customers about how they’ve used Power BI to improve collaborative business processes in their organization, we often hear that Power BI is used to summarize and visualize data that many end users are entering into tools like Excel files, SharePoint lists, or the Common Data Service. Business processes like managing a team’s budget requests, planning hiring activities, and evaluating marketing campaigns can all fit this pattern.

With these sorts of processes, users often expect Power BI reports to be updated as soon as they enter data in underlying systems. Power BI’s existing fixed refresh schedules are not sufficient to accomplish this and manually refreshing the Power BI dataset each time your access a report adds extra steps and creates confusion.

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 action to the Power BI connector for Microsoft Flow. Now, you will be able to trigger dataset refreshes based on hundreds of Flow triggers. Whether your trigger is based on changes to items in your SharePoint list or updates to an Excel file in OneDrive or SharePoint Online or a complex day and time schedule, there are dozens of use cases for this action.

Excited? Read on for a full tutorial of using the new refresh a dataset action to automate refreshing a Power BI report based on changes to a SharePoint list. Or, head on over to Flow to try it out for yourself.

Tutorial: Trigger dataset refresh for SharePoint lists or OneDrive Excel files with Flow and Power BI

In this tutorial, we will create a Flow that triggers a dataset refresh whenever items in a SharePoint list are updated.

Consider an example where you are the office administrator for Northwind Traders and you have been given the responsibility of ensuring the office is well stocked with office supplies, by monitoring inventory, placing new orders, and maintaining the overall budget for the team. You might have a report that looks something like this:

Furthermore, imagine that various employees in the company have access to a SharePoint list to report supplies that are getting low in their parts of the office:

To ensure you have an accurate picture of your supply requests and budget levels, any requests made on this SharePoint list should immediately reflect in the report. Instead of having to manually refresh your dataset each time you or someone else views the report or wait until the next scheduled refresh, you can easily automate this process using the new dataset refresh action in Flow.

To get started, navigate to Flow. Sign in, and then go to My Flows, then choose + New, and select + Automated – from blank from the drop-down. You should see the following:

Go ahead and give your Flow a name and select a SharePoint trigger depending on your use case. In this example, since we want the Flow to trigger when there’s a new row added to the list, choose When an item is created or modified.

Next, click on the + New step button, then enter ‘power bi’ in the search box. You should see a list of actions like below:

Then choose the new Refresh a dataset action.

Now, we’re at the last step of the Flow: Select the name of the workspace, then the name of the of the dataset that you want to trigger the refresh for. In our case, we have chosen Northwind Traders workspace and Northwind Budget Tracker dataset.

And that’s it! Select Save and ensure your Flow is turned on. Now, whenever there is a new supply request made in the SharePoint list, your budget tracker dataset should automatically refresh.

Going back to our budget tracking example for Northwind Traders, if there is a new request made to the Supplies Request SharePoint list that exceeds the budget:

Your flow will trigger and the dataset will automatically update. Considering this individual, placed an order for 500 4K monitors, you will certainly know when you’re out of budget next time you visit the Northwind Budget & Supplies tracker report:

Next steps

Try out the feature! Head on over to Flow and use the new refresh action to automate your refreshes
Existing limits on refreshes apply when running the refresh dataset action in Microsoft Flow. For datasets in shared capacity used by Power BI Pro, your refresh action is limited to eight refreshes per day (including refreshes executed via Scheduled Refresh). In Premium capacities, there is not limitation on the number of refreshes per day, although you are limited by the available resources in your capacity. If there are not sufficient resources, the refresh execution may be throttled until the load is reduced. If this throttling exceeds 1 hour, the refresh will fail.
For more ideas on Flows, check out some of our existing Flow templates that allow you to add data from Flow into a Power BI dataset or use data alerts to trigger a Flow whenever the data changes. In the coming weeks, we’ll also be adding several Flow templates with the new refresh a dataset action, including the one featured in the tutorial above – so stay tuned for that.
Have any feedback? Have an idea for another way that Power BI can connect to Flow? We’d love to hear it! Please leave comments below or in the Power BI community forums

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Power BI Dataset data source support for Paginated Reports is now available

April 29, 2019 Self-Service BI

As discussed in our blog post announcing support for Azure Analysis Services, we promised to unlock the critical capability of allowing Paginated Reports to be built on the same enterprise semantic model as your interactive reports. This week for “New Feature Friday”, we’re pleased to announce that Power BI Datasets in premium workspaces are now supported as data sources for your Paginated Reports. While we announced the ability for authors to create reports using Power BI datasets (via the XMLA endpoint) in Power BI Report Builder three weeks ago, we’ve now unlocked the capability to publish these reports to the service and be shared widely across your organization either via apps or e-mail subscriptions.

Please note the XMLA endpoint will be enabled again in production by April 28th.

Create paginated reports with Power BI Datasets

To create a paginated report using Power BI datasets with Power BI Report Builder, you can select SQL Server Analysis Services as your source and connect to your Power BI Dataset using the instructions discussed in the announcement for XMLA support. With paginated reports, you may choose one or more Power BI datasets to connect to in the same report, as there are no restrictions on the number of live data sources a report author may use. Both Power BI datasets using imported data or Direct Query can be used with your paginated reports. Be sure to read the documentation about creating reports with Report Builder to learn more about authoring paginated reports.

Upload to Power BI

After you have saved your paginated report file, you can then go to the Get Data screen within the service and upload your report to a Premium workspace. You’re not limited to the same workspace as your Power BI datasets being used for your paginated reports, so you may choose any workspace in your Premium capacity to publish your reports to. As always, when you consume the semantic model(s), the role-based security (RLS) defined in the model is honored for each user regardless of tool, and this is the same for Paginated reports.

Distribute your paginated reports across the organization

You can easily share your paginated reports you’ve created now against your Power BI datasets either via individual report sharing, apps, or e-mail subscriptions. You may subscribe yourself or other users to these reports with a full PDF of the report attached. Make sure you read the documentation to learn more about the specific paginated report capabilities around e-mail subscriptions.

This has been a top feature ask since we first launched paginated reports, and we’re excited to hear your feedback. We’ll have another post next week announcing more new features for Paginated Reports, including additional data source support. Have a wonderful weekend!

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Google releases dataset to help AI systems spot fake audio recordings

February 1, 2019 Big Data

When Google announced the Google News Initiative in March 2018, it pledged to release datasets that would help “advance state-of-the-art research” on fake audio detection — that is, clips generated by AI intended to mislead or fool voice authentication systems. Today, it’s making good on that promise.

The Google News team and Google’s AI research division, Google AI, have teamed up to produce a corpus of speech containing “thousands” of phrases spoken by the Mountain View company’s text-to-speech models. Phrases drawn from English newspaper articles are spoken by 68 different synthetic voices, which cover a variety of regional accents.

“Over the last few years, there’s been an explosion of new research using neural networks to simulate a human voice. These models, including many developed at Google, can generate increasingly realistic, human-like speech,” Daisy Stanton, a software engineer at Google AI, wrote in a blog post. “While the progress is exciting, we’re keenly aware of the risks this technology can pose if used with the intent to cause harm. … [That’s why] we’re taking action.”

The dataset is available to all participants of ASVspoof 2019, a competition that aims to foster the development of protections for and countermeasures against spoofed speech — specifically, systems that can distinguish between real and computer-generated speech.

“As we published in our AI Principles last year, we take seriously our responsibility both to engage with the external research community, and to apply strong safety practices to avoid unintended results that create risks of harm,” Stanton wrote. “We’re also firmly committed to Google News Initiative’s charter to help journalism thrive in the digital age, and our support for the ASVspoof challenge is an important step along the way.”

AI systems that can be used to generate misleading media have come under increased scrutiny recently. In September, members of Congress sent a letter to National Intelligence director Dan Coats requesting a report from intelligence agencies about the potential impact of deepfakes — videos made using AI that digitally grafts faces onto other people’s bodies — on democracy and national security. Members of Congress speaking with Facebook COO Sheryl Sandberg and Twitter CEO Jack Dorsey also expressed concern about the potential impact of manipulative deepfake videos in a Congressional hearing in late 2018.

Fortunately, the fight against them appears to be ramping up. Last summer, members of DARPA’s Media Forensics program tested a prototypical system that could automatically detect deepfakes, or manipulated images or videos, in part by looking for cues like unnatural blinking in videos. And startups like Truepic, which raised an $ 8 million funding round in July, are experimenting with deepfakes detection as a service.

Let’s block ads! (Why?)

Big Data – VentureBeat

Google makes dataset of 50 million drawings available on its cloud

November 15, 2018 Big Data

You can tell a lot about a person by the way they doodle. That’s the conceit behind Quick Draw, an interactive web experiment launched by Google’s Creative Lab in November 2016. It recruits intrepid web surfers to illustrate prompts with sketches, all the while leveraging artificial intelligence (AI) to attempt to identify what was drawn — sort of like a high-tech version of Pictionary.

Quick Draw has collected more than 1 billion drawings across 345 categories, 50 million of which Google open-sourced last year — complete with metadata, including prompts and geographical user locations. Today, it’s making them available through Google Cloud Platform (GCP) in the form of an API and an accompanying Polymer component. (Polymer, for the uninitiated, is an open source JavaScript library for building web applications.)

Starting this week, any GCP customer who joins the public Google Group can add the API to their library by searching for it and adding it to a project. With the Polymer component, doodles can be displayed in a web-based app with a single line of code.

“When we release the dataset, it was basically a file for every one of the 345 categories, and it was a little bit cumbersome to work with,” Nick Jonas, creative technologist at Google’s Creative Lab, told VentureBeat in a phone interview. “A lot of these studies that have been done over the past year are large analyses on the entire dataset. We got some feedback from developers who said they wanted an easier way to prototype with the data quickly.”

Google makes dataset of 50 million drawings available on its cloud

Above: Adding the Quick, Draw! API to a project in Google Cloud.

Image Credit: Google

The Quick Draw API — which uses Google Cloud Endpoints to host a Node.js API, Jonas explained — provides access to the same 50 million files contained in the original dataset, but obviates the need to download them in their entirety. It returns a JSON object or an HTML canvas rendering for each drawing — one doodle.

“It’s a way for users not to have to download gigs and gigs of data before they can start playing with it,” Jonas said.

There are surprising insights to be gleaned from the data. A study by Quartz in June found that 86 percent of U.S. players drew circles counterclockwise, while 80 percent of Japanese drew them clockwise. (The difference, the publication found, can be attributed to the top-left-to-bottom-right stroke order in Japanese writing.) Meanwhile, an internal survey out of Google Research discovered that users from Western countries tend to doodle fish facing the opposite direction from those drawn by Asian users.

The dataset’s also been used creatively. British artist Neil Mendoza used a face-tracking algorithm to apply Quick Draw sketches atop a human head, and German-based computer scientist Deborah Schmidt tapped a subset of 300,000 random doodles to fill in letter templates with collages.

Above: Neil Mendoza mapping Quick Draw facial features to a human face.

Image Credit: Neil Mendoza

In the future, the team is considering migrating the doodles to a database, which would afford fine-grain access control. In theory, users would be able to perform queries like “Give me a recognized drawing from China in March 2017.”

“I just want to encourage people to use [the dataset] in new ways and to contribute and see how this can possibly expand,” Jonas said. “I just want to encourage developers to play with it.”

Let’s block ads! (Why?)

Big Data – VentureBeat

#powerbi – Switching a report from one PowerBI dataset to another PowerBI dataset

September 22, 2018 Self-Service BI

At the Power BI world tour in Copenhagen last week I was asked how to change a Power BI report’s connection from a dataset in the service – for instance if you have a test workspace and then want to move the report to a production workspace.

I started to refer to my previous blogpost – https://eriksvensen.wordpress.com/2017/10/03/how-to-change-the-powerbi-desktop-file-connection-from-data-model-to-a-power-bi-service-dataset-or-azureas/ – but when using this hack it won’t work.

So we have to do it in another way and it is quite simple – one important thing is of course that the dataset has the same dimensions and measures – otherwise some of your visualisations will show an error.

When we create the report we can select a Dataset from the service

#powerbi – Switching a report from one PowerBI dataset to another PowerBI dataset

When we save the report it will automatically be saved in the workspace where the dataset resides.

But how can we change it –

If you go to Edit Queries

#powerbi – Switching a report from one PowerBI dataset to another PowerBI dataset

You can click Data source settings – then we will get the option to pick a dataset from another workspace

#powerbi – Switching a report from one PowerBI dataset to another PowerBI dataset

And then you just pick the dataset you want to use.

When you save the report now – the report will be saved in the workspace where the selected dataset resides.

Hope this can help you as well – and if so give this post a like

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

How to (efficiently) generate and catch some data-set that has similar correlation?

May 24, 2018 BI News and Info

Correlation[x1 = RandomReal[10, 10], y1 = RandomReal[10, 10]]
ListPlot[Thread[{x1, y1}], Frame -> True]
Correlation[x2 = RandomReal[10, 30], y2 = RandomReal[10, 30]]
ListPlot[Thread[{x2, y2}], Frame -> True]

I have started with some basic lines, which will generate some random points.
Call the {x1,y1} dataset 1 and {x2,y2} the dataset 2.

I then want to Catch the two set when they have similar Correlation, for example, both are 0.43 to 2 decimal places, then plot them side by side.

Or -0.453 to 3 decimal places, then plot them side by side.

What’s the best way to do it?

Thanks.

Let’s block ads! (Why?)

Recent Questions – Mathematica Stack Exchange

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

August 20, 2017 Self-Service BI

August 16, 2017 / Erik Svensen

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

I am working on a project where customer would like to update a PowerBI dataset when specific events occur – in their case when an email with a specific subject arrives in a specific mailbox – and we succeeded by using Microsoft Flow, Azure Functions and PowerBI REST API.

But as I recently bought flic buttons (https://flic.io/) so I wanted to change the setup a bit so the dataset is updated when I click the button – sort of my first IOT project.

The ingredients

1 dataset in your PowerBI tenant that can be scheduled for refresh
1 Power BI Pro license (or premium if you want more than 8 refreshes a day)
1 Registration of an Application for Power BI ( link – https://dev.powerbi.com/apps )
1 Azure subscription
1 Power Shell script
1 Azure Function/Logic App
1 Microsoft Flow license in any tenant
1 Flic button
10-15 minutes

First up – the information about the dataset and the group

We need the dataset ID and group ID where the dataset is placed.

The easiest way to find it is to navigate to the settings and the dataset tab and click the data set – the group ID is in blue area and the dataset ID is in the red box,

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Notice that the Scheduled refresh is set to Off.

Get a client ID for your Power BI Application

You will need to register an application for the update and you can do this via

The App Type has to be Native app and the Redirect URL must be – urn:ietf:wg:oauth:2.0:oob

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Select both the Dataset API’s and in step 4 click to register the App and save the Client ID.

Powershell script to update the dataset

You can find the Powershell script here – https://github.com/Azure-Samples/powerbi-powershell/blob/master/manageRefresh.ps1

Fill in the $ ClientID, $ groupID and $ datasetID in the script.

In order to avoid popup windows with authentication in the Azure Function I had to modify the script and hardcode the username and password in my script.

$ userName = “username”

$ password = “password”

$ creds = New-Object “Microsoft.IdentityModel.Clients.ActiveDirectory.UserCredential” -ArgumentList $ userName, $ password

$ authContext = New-Object “Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext” -ArgumentList $ authority

$ authResult = $ authContext.AcquireToken($ resourceAppIdURI, $ clientId, $ creds)

The bold lines are added and the $ authResult is modified as well.

Azure Function

Log on to the Azure portal – https://portal.azure.com/ and create a Function App

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Wait for the deployment to finish – it takes about 1-2 minutes.

Choose to create your own custom function

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Select language Powershell

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

And the HttpTrigger

In my example, I will keep authorization level to anonymous – but you can add more security if needed.

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Now replace the script with the PowerShell script from the previous section.

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Now you can save and click run to see if the script works

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

If the script succeeds – you can check whether the dataset is updated via the Power BI dataset refresh history

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

By clicking Get Function URL

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

We will get the POST Url that we will use later in our Flow.

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Now – Microsoft Flow

Open your Microsoft Flow in your Office 365 portal and create a new blank flow

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Now we can select between a lot of different triggers that can activate our data refresh in Power BI. It could be certain tweet, a mail in an inbox or in onedrive and many more – we currently have 160 triggers to choose from.

In my example, I want to integrate with a flic button

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

And by connecting to my Flic account I can choose the button I want to use and which Event (it has click, double click and hold) it should be attached to on the button

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

To activate the refresh, I add a new step as an action I choose the HTTP where I can post the URL to the function.

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

After the HTTP action, I add a new step that sends and email to me – with information about the refresh and which button was presses and where it was located when pressed.

Then save the flow and we should be ready to update the dataset via the button

Trying the flow

So by clicking the button we can see the Run History

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

As you can see the flow ran as 23:25

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

And when checking the refresh history in Power BI we can see its refreshed –

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

And I get an e-mail as well

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

OBS – The refresh can “only” be done 8 times with a Power BI Pro License but 48 if you should be so lucky that you can have access to a premium edition.

Wrapping up

I have been so fun to create this and it was surprisingly easy – with off course some challenges underway.

But the toolset is amazing and combining Flow and Power BI opens a lot of possibilities and ideas to activate refreshes and do stuff with the Power BI REST API triggered by different events.

I will at least have an extra look at the API and see what can be done – link to documentation

Let me know if you find this interesting.

Applying functions to some columns in a Dataset and keeping only those

November 21, 2016 BI News and Info

Take the following example Dataset:

data = Table[Association["a" -> i, "b" -> i^2, "c" -> i^3], {i, 4}] // Dataset

PZSgO Applying functions to some columns in a Dataset and keeping only those

Picking out two of the three columns is done this way:

data[All, {"a", "b"}]

LG3jU Applying functions to some columns in a Dataset and keeping only those

Now instead of just returning the “a” and “b” columns I want to map the functions f and h to their elements, respectively, and still drop “c”. Based on the previous result and the documentation of Dataset I hoped the following would do that:

data[All, {"a" -> f, "b" -> h}]

Wvwml Applying functions to some columns in a Dataset and keeping only those

As you can see, the behavior is not like the one before. Although the functions are mapped as desired, the unmentioned column “c” still remains in the data.

Do I really need one of the following (clumsy looking) alternatives

data[All, {"a" -> f, "b" -> h}][All, {"a", "b"}]
data[Query[All, {"a", "b"}], {"a" -> f, "b" -> h}]
Query[All, {"a", "b"}]@data[All, {"a" -> f, "b" -> h}]

to get:

q62un Applying functions to some columns in a Dataset and keeping only those

or is there a more elegant solution?

Let’s block ads! (Why?)

Recent Questions – Mathematica Stack Exchange

Tag Archives: Dataset

Find all queries to Azure AS from a Power BI report or dataset

Refresh your Power BI dataset using Microsoft Flow

Tutorial: Trigger dataset refresh for SharePoint lists or OneDrive Excel files with Flow and Power BI

Next steps

Power BI Dataset data source support for Paginated Reports is now available

Create paginated reports with Power BI Datasets

Upload to Power BI

Distribute your paginated reports across the organization

Google releases dataset to help AI systems spot fake audio recordings

#powerbi – Switching a report from one PowerBI dataset to another PowerBI dataset

How to (efficiently) generate and catch some data-set that has similar correlation?

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

The ingredients

First up – the information about the dataset and the group

Get a client ID for your Power BI Application

Powershell script to update the dataset

Azure Function

Now – Microsoft Flow

Trying the flow

Wrapping up

Applying functions to some columns in a Dataset and keeping only those

Recent Posts

Categories

Archives

Tag Archives: Dataset

Share this:

Share this:

Tutorial: Trigger dataset refresh for SharePoint lists or OneDrive Excel files with Flow and Power BI

Next steps

Create paginated reports with Power BI Datasets

Upload to Power BI

Distribute your paginated reports across the organization

Updating a #PowerBI dataset using Microsoft #Flow, #Azure Functions and a #Flic button

The ingredients

First up – the information about the dataset and the group

Get a client ID for your Power BI Application

Powershell script to update the dataset

Azure Function

Now – Microsoft Flow

Trying the flow

Wrapping up

Recent Posts

Categories

Archives