Troubleshooting Power BI PowerShell issues to view the error
I have been recently using the Power BI PowerShell modules to get some information from the Power BI APIs to store the data. I ran into an issue where something was not working and I found a great cmdlet which allowed me to view the Power BI errors that I had been querying via PowerShell. NOTE: To use the PowerShell…
Power BI Premium/Premium Per User – Automating Processing of historical partitions
I recently had a big challenge with one of my customers where due to the sheer volume of data and network connectivity speed I was hitting the 5-hour limit for processing of data into my premium per user dataset. My solution was to change the partitions from monthly to daily. And then once I have all the daily partitions merge…
Using PowerShell to run Power BI DAX queries and extract data to CSV
In this blog post I am going to show you how to use PowerShell to run a DAX query from my dataset, and then store the results in a CSV file. I will also include the PowerShell code! I really liked the awesome blog post by Kay on the Power BI Team which you can find here: Announcing the public…
How to convert XLS files to XLSX so that they can be used in #PowerBI
I recently was having a challenge which we all have had when working with Power BI. The customer I was consulting to have all their data extracts saved in XLS (The dreaded XLS!) I thought that there must be a way to convert them quickly and easily, which I found after Googling ( I honestly cannot find the link to…
BI-RoundUp – Power BI (Working with PowerShell in Power BI – Deprecation of Custom Visuals API 1.1)
Here is the weekly BI-RoundUp and at least this week it will be a quick read! Power BI – Working with PowerShell in Power BI I am not going to go into great detail here, due to Kay giving a detailed explanation how to use the PowerShell cmdlets. What I will say is that after reading through the above blogpost…
How many times has my Power BI dataset been refreshed?
Have you ever wondered how many times your Power BI dataset has been refreshed? And if you are using Power BI Pro, you are limited to 8 refreshes a day. This week’s blog post I am going to demonstrate how you can use the Power BI API to view all your data refreshes for a particular dataset. If you need…
Using the Power BI API with PowerShell scripts – Refreshing your dataset
I know when I started trying to use the Power BI APIs, I was unsure of what I was doing, and how I could get it working. Not only that, but I could see that as with building any cloud platform the APIs have to be there before they can put the skin on and make it easy to use….
Automating running PowerShell script which required Administrator elevation via SSIS
UPDATE (08 AUG 2016): I have updated this to use a SQL Server Agent Job instead of the Task Scheduler which proved to not be reliable. What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will snapshot a database using Xtreme IO from EMC. In…
Automating running PowerShell script which required Administrator elevation via SSIS
What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will run with elevated privileges. So in order to complete this we have to complete the following below but use a simple PowerShell script which will get all the FileNames from a Folder. Create a BAT…
SSIS – Automating SQL Server Backups, copying files and checking that they were copied
I had an issue where I lost all my backups. So what I have now created is an automated SQL Server backup process, which will back up all the databases, verify the backups, copy them to the required location. And then finally email the backup files copied to ensure that they are all there. …