![]() ![]() ![]() We only need to create the connection and this will add the data from the database to the PowerPivot model. So how could we do this – let’s start by adding some data from the AdventureWorksDW to a data model in the workbook. Inspired by Chris Web’s blog post about Dynamic DAX Query Tables in Excel 2013 – link – I have tried to create a dynamic table from PowerPivot data without using VBA so it would be possible to publish it on SharePoint and browse the model using Excel services. “You do not have a model or the model is empty” – Not really true - #PowerPivot.Quick #PowerQuery trick – Get duration days between two dates.#PowerQuery – Filter a table based on another table column or list – and some Filter aha’s.Specifying JSON Query in Power Query – Example Statistics Sweden.#PowerQuery - Replicate doing an Excel VLOOKUP in M.I have been playing around with the new awesome (preview) feature in the December Power BI Desktop release where we can use DirectQuery for Power BI datasets and Azure Analysis services (link to blogpost) In my case I combined data from a Power BI dataset, Azure Analysis Services, and a local Excel sheet. #PowerBI – Change the data source in your composite model with direct query to AS/ Power BI Dataset The scenario Imagine a simple star schema where we have a fact table with sales and a customer and Date dimension. And was encouraged to write a blog post about this – so here it is □. Yesterday I tweeted about how I solved the implementation of a Many 2 Many filter using Calculation groups. So, I decided to write a blog post on how you can do it – Using Calculation Groups in #PowerBI to implement a Many 2 Many (M2M) filter I have had a couple of people posting comment on one of previous blogposts “Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate” asking me on how to specify values for multi value parameters in a Paginated reports. As I want it as a table I use the Ribbon interface to convert the list of dates into a table Which then gives Multivalue parameters in #PowerBI paginated report when using #PowerAutomate to export to file When I build date tables I typically use the function List.Dates to create a list of dates. Here is a tip that reduces your Power Query steps with 1 step less. When you build a date table in Power Query you might use the functions under Date to add year, month and day And this will give you three steps in your Query But we can do this a bit faster, and you will save a few clicks with your mouse If you add a custom How to avoid a rename step in #PowerQuery when you use Table.FromList – #PowerBI #PowerQuery – Add Year, Month and Day to your date table with Date.ToRecord – #PowerBI ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |