Why is my #PowerBI dataflow refresh failing
I was recently testing out the new awesome dataflows in Power BI, and no matter what I did my dataflow refresh would fail. I was getting the same error no matter what I did. In order to find the error details for my dataflow I…
Power BI RoundUp – Export to PDF & On Demand Email Subscriptions | Premium Capacity Metrics App Update | Difinity Conference | Power BI APIs with Service Principal | Bulk Operations in the Admin Portal | Webinar on Personal Bookmarks in the Power BI Service
Hi there, I cannot believe it is already February. This year is already starting to fly by. Please find below my weekly Power BI Round Up. Export to PDF & On Demand Email Subscriptions As you can see above you can now schedule your email…
Where can I find all the data sources for my #PowerBI report?
I have found that at times people get other Power BI reports and are not sure what data sources there are in the file. As well as which data sources are connecting to what? In this blog post below, I will show you where you…
Power BI RoundUp | Time-Based Scheduling for Email Subscriptions | Power BI Report Server Update | On-Premise data gateway in the Power Platform | Monetization option for Power BI Custom Visuals
It is great to be back and already into the swing of a new year. 2019 has already started with a lot of new features already coming into the Power Platform. I am looking forward to the year ahead and no doubt will see a…
How do you quickly change Text Size or other Visual Properties all at once in a Power BI report?
I was working on a larger Power BI report and there were quite a lot of tables, where the text size needed to be changed. Using the new search box feature in the Formatting options I searched for Text. This then gave me all the…
Are my DirectQuery Tables still in DirectQuery Mode, how to ensure they stay that way?
I have been doing some work with Power BI Composite models, and what I have found is that often the DirectQuery table can be changed to an Imported table. I personally feel that this blog post will be an important reference for me and hopefully…
Power Query – Changing DateTime columns data types to Date without specifying the column names
This blog post I will demonstrate how to change a DateTime column data type to Date dynamically. You might be wondering what I mean by dynamic, this means that I will not specify any actual column names. The code will find the column names based…
The Complete Power BI Infographic – Update for Dec 2018
I recently had a look at my last version of my Infographic and I realized that I had not updated it for a few months and there has been a lot of incredible additions to the Power BI ecosystem. My infographic not only contains the…
Power BI RoundUp – Power BI Desktop Dec Update – Dataflows Integration with your own Azure Data Lake – Business Application 2019 – Developer Update Nov 2018 – Windows App Update
It appears that there is one last massive push from the Power BI team before the end of the year. I would consider this my early Christmas present, so please enjoy and read below. Power BI Desktop Update Dec 2018 Once again it is another…
Converting Multiple Items into One Row in Power Query
I was working with some external data where I had a list of Australia postal codes, the challenge is that there are multiple suburbs that are part of one postal code. Below I am going to show you how I took the multiple suburb names…