Recent Posts: Erik Svensen - Blog about Power BI, Power Apps, Power Query

If you find yourself clicking the same button in the Power BI Desktop you might find this little tip useful. When you right click a button in the ribbon – you can add it to the Quick Access Toolbar. This will add the button at the top (unless you have positioned it below the ribbon) […]

Unfortunately I wasn’t able to participate in the Microsoft Business Application Summit this year – but luckily we can watch all the session via https://community.powerbi.com/t5/MBAS-Gallery/bd-p/MBAS_Gallery But that would mean I had to leave Power BI Desktop in order to search and watch the videos – and the website also made it hard to see the […]

One of the things you should know when working with PowerQuery is that you can get a list of all functions in M by adding a blank query and use the #shared expression to get all the functions. This can be turned into a table by clicking the “Into Table” button on the ribbon and […]

After the Azure Analysis Services web designer was discontinued per march 1 2019 – link – there is no official tool to do a move of a PBIX datamodel to Azure Analysis Service. But by using a few different tools we do have ways of doing it anyway. Step 1 – DAX Studio Open your […]

One of my clients called me the other day and asked whether it was possible to export the selected order that was selected in the current report page – as she wanted to send the information to another user. I explained the export data feature from the visual action menu but she didn’t want to […]

If you are interested in learning how I scraped the web page for all the relevant data – check out these functions to extract data from pages using CSS query capabilities in the power query function Html.Table