Connect Power BI with SQLite and Primavera P6 | Vahid Doustimajd
Connect Power BI with SQLite and Primavera P6 Primavera P6 is the most potent, practical and one of the main software that experts use in Project Management for scheduling, and in that field, reports and dashboards are critical. The P6 Standalone has an SQLite database, and Power BI does not have a Certified Connector for the SQLite, so in this meeting, I'll explain how to connect Power BI with SQLite and Primavera to create a report. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Vahid Doustimajd: He is a Microsoft Certified Trainer and technophile person with plenty of enthusiasm to look for and find smart solutions. His background is in project management, and He hase spent most of my career in related areas of the profession. Most recently, though, driven by his passion for Excel, VBA, and preparing dashboards, He decided to change his career to work as a Power BI Developer and Data Analyst. Power BI addict, blogger, PBI Community Super User, User Group Leader, and learner. This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Vahid: LinkedIn: https://www.linkedin.com/in/vahid-dm/ Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.Learn M language (Power Query) from the UI
Power Query is a fabulous tool for cleansing and then loading data into Power BI and Excel. The UI is excellent and it lets you do almost everything you can imagine just by clicking on the menu options. Yet under the hood of Power Query is a very powerful functional language called โMโ. There is now Intellisense that supports the M language in the UI, but you can also learn a lot about how the language works by using the UI to teach you. In this session Matt will introduce the basics of the M language and demonstrate concepts on how to learn more as you write you queries. ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ (๐๐ ๐๐๐๐ข๐จ): https://bit.ly/3PU7EsW ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: EnglishHybrid Tables in Power BI | Shabnam Watson
Hybrid Tables in Power BI Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time! Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BIโs memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system. Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery). Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Shabnam Watson: Shabnam Watson is a Business Intelligence consultant and Microsoft Data Platform MVP with 20 years of experience developing Data Warehouse and Business Intelligence solutions. She has worked across several industries including Supply Chain, Finance, Retail, Insurance, and Health Care. Her areas of interest include Power BI, Analysis Services, Performance Tuning, PowerShell, DevOps, Azure, Natural Language Processing, and AI. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI. She is a regular speaker and volunteer at national and local user groups and conferences. She holds a bachelorโs degree in Computer Engineering, a masterโs degree in Computer Science, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI). This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Shabnam: LinkedIn: https://www.linkedin.com/in/shabnamwatson/ www: https://shabnamwatson.wpcomstaging.com/ Twitter: shbwatson Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.
Accumulative, conditional accumulative in Power Query
Scenario: In Power BI, we sometimes meet cumulative problem. For basic direct accumulation we could use Dax language or M language. But for conditional accumulation and group conditional accumulation, we tend to use M language. The following will be divided into three cases to gradually explore the cumulative summation.
Create a mutable global variable in M language
Hi, community, I'm working on a custom connector that needs to authenticate before data representation is done, and to do this I don't want to hardcode the auth credentials in my source code. So, I declared a global list variable named config = {"a"}; and in the shared MyCustomConnector.Contents function, I'm doing a List.ReplaceValue on item "a" in the list above. shared MyCustomConnector.Contents = (BaseUrl as text, ClientId as text) => List.ReplaceValue(config, "a", BaseUrl, Replacer.ReplaceText); so in my StartLogin function, I can just call the config by index like this. //Start Login StartLogin = (resourceUrl, state, display) => let AuthorizeUrl ="https://"&Text.From(config{0})&"/oauth/authorize?" & Uri.BuildQueryString( [ client_id = "11", response_type="code", state = state, redirect_uri = redirect_uri ] ) in [ LoginUri = AuthorizeUrl, CallbackUri = redirect_uri, WindowHeight = windowHeight, WindowWidth = windowWidth, Context = null ]; But it appears that, the List.ReplaceValue is not being executed because whenever I try to set credential for authentication, "a" is being passed into the URL. Any help will be much appreciatedM language create '445' date table where first day of the year is Monday & Periods of 4 or 5 weeks
Hi, I need to create a date table with the 445 principe in query editor. The first day of the year is the first Monday of the year. One year includes 12 Periods and 4 Quarters. In every quarter you have 3 periods according to the 445 principe. 1st period and 2nd period include 4 full weeks. 3th period 5 full weeks. See the below image with an example for the year 2022. I need in my date table a column Week of Year and Period of Year. In 2022 to first Monday is 3 jan. Week 1 of the year is from 3jan till 9jan. Week 2 is from 10jan till 16jan. Period 1 starts 3jan till 30jan. Period 2 is from 31jan till 27 february. Example 2022 Anyone an idea on how to write this in M language? Thank you!
Can you accomplish this in PowerBI:
I'm not certain this is even possible, or within the realms of PowerBI; but I know this is the right place to ask! I have a stock movements table that looks like this: It has various types of stock movements from Stocktakes, through to Deliveries and Sales, Etc..... Every Stock Movement creates a stock line, and the running total is written to the line at that time. Our users would like to select a specific Date / Time, and have the system return the total value of stock on hand based on their input. I have deduced that the following logic would give the correct result: A User to define Date on which they would like the Total Stock on Hand results returned Set the User Defined Date as the "End Date" Using a given input date, return the closest Stocktake date prior to the date Set the closest stocktake date prior to that date as the "Start Date" Return a sumarised Table showing the most recent Movement Records for each distinct Item Between the User Defined Date (End Date), and the Stocktake Date (Start Date) Result to deliver a table including Item, Running Totals & Value. Based on the above, and a user input parameter of: 09/03/2021 22:00; I would expect the resultant table to look like this:: I'm fairly new to PowerBI, so have a few questions: Can PowerBI accomplish this? (Returning / Filtering a Table from a user input Paramter) How would you do this in the PowerBI UX? Is this a DAX or a M Query type question? Any hints as to how I might accomplish this would be greatly welcomed!!! Regards Robbie
