Loud and Clear!! Thank you for this informative video!!
@sundarshiva9 ай бұрын
Very helpful thank you si much... Kindly do few more real time projects
@KSRDatavizon9 ай бұрын
Sure 👍
@harshitsingh8533 Жыл бұрын
You're amazing, clear & precise. Thank you for your valuable efforts and time.
@KSRDatavizon Жыл бұрын
You are so welcome, Please susbcribe our channel for regular updates.
@seshulatha2 ай бұрын
Nice and clear explanation ..Thank you so much 🎉
@KSRDatavizon2 ай бұрын
You are welcome 😊
@seshulatha2 ай бұрын
Very nice 🎉
@KSRDatavizon2 ай бұрын
Thank You
@sayedramadan8467 Жыл бұрын
Thank you very much. I benefited a lot from the video
@KSRDatavizon Жыл бұрын
Glad it was helpful!, Please subscribe our channel for regular updates
@divyajeetsingh5049 Жыл бұрын
Great tutorial short and to the point!
@KSRDatavizon Жыл бұрын
Glad it was helpful! Thank you, Please subscribe our channel for regular updates, its motivate us
@chandramary1539 Жыл бұрын
Useful session ! Very easy to understand and clear voice.
@KSRDatavizon Жыл бұрын
thank you so much
@kasi663 Жыл бұрын
Quite a useful session, thank you
@satyabobby6248 Жыл бұрын
Informative.thank u..
@mohdmuzammil3059 Жыл бұрын
Thanks giving
@sheharakalansuriya41004 ай бұрын
❤ love this video
@KSRDatavizon2 ай бұрын
Thanks for watching! I'm glad you enjoyed it. If you have any other questions or would like more information on freelancing, feel free to ask.
@uravshukla9 ай бұрын
Can we go back to the SQL query dialog box or do we have to start from scratch? I know we can change it from the M query but that doesn't look very friendly interface
@KSRDatavizon2 ай бұрын
Yes, you can go back to the SQL query dialog box in tools like Power BI or Excel Power Query Editor without having to start from scratch. Here’s how you can do it without directly modifying the M Query, which can indeed seem a bit tricky. Power BI / Power Query Editor: If you’ve already loaded data using a SQL query and now want to modify that query: 1. Navigating to the SQL Query Dialog Box: Open Power Query Editor by clicking on Transform Data in the Home ribbon. Find the query you want to modify on the left pane. Right-click on the query and select Advanced Editor or just click Source in the Applied Steps pane. You should see the original SQL query there. 2. Modifying the SQL Query: Instead of editing the M Query, you can modify the SQL query itself. Look for a step called Source in the Applied Steps pane. Click on this step, and it should bring up the SQL dialog box that was originally used to input the query. 3. Edit SQL Query Directly: In the Source step, you’ll see something like: m Copy code Sql.Database("YourServerName", "YourDatabaseName", [Query="SELECT * FROM YourTable"]) You can click into this field and edit the SQL directly or paste a new query. Excel Power Query (Data -> Get & Transform): Follow the same steps in Power Query Editor in Excel. Right-click on the table in the Queries pane and choose Advanced Editor or Source from Applied Steps to modify the SQL query. Starting Over: If you prefer not to mess with the editor at all and just want to load new data or change the SQL query entirely, you can simply: Go to the Home tab in Power Query Editor. Click New Source, select SQL Server, and re-enter your new SQL query. Load the data fresh, while keeping the old steps intact as a backup if needed. Friendly Interface Tips: The Advanced Editor is great for SQL-savvy users, but if you prefer to stick with the interface and not dive into M queries, focusing on the Source step is usually sufficient. You can also copy-paste the original query into the editor, modify it, and re-run it directly from there.
@Aks.12311 Жыл бұрын
do another vdo for sql server and how to work with dax when connected with direct query
@KSRDatavizon Жыл бұрын
sure, will plan shortly
@uravshukla8 ай бұрын
What if my query has a relative date clause? I tried parameterizing the "7" and it is throwing me an error where date>= dateadd(days, -7, current_date)
@anasabdullah1799 Жыл бұрын
If we publish the dashboard and do a schedule refresh is it gonna updated automatically or we need to run the sql report first?
@KSRDatavizonАй бұрын
Hi Anas, thanks for your question! When you publish a dashboard in Power BI and set up a scheduled refresh, it will update automatically according to the schedule you configured. However, if your data source relies on an SQL report or a query that needs to be run first, you may need to ensure that those processes are completed before the refresh occurs. It's important to check the refresh settings and the dependencies of your data sources to ensure everything updates as expected. If you have any further questions, feel free to ask!
@ranjith1083 Жыл бұрын
can you share any power bi resume for 5+ relevant experience
@KSRDatavizon Жыл бұрын
www.datavizon.com/s/pages/resume
@ranjith1083 Жыл бұрын
@@KSRDatavizon thank you, can you suggest me any technologies which i should be very strong to keep my career better as a power bi developer
@benis4913 Жыл бұрын
Hi Ma'am I'm getting stuck with the starting stage to enter into the MySQL after installed how can I connect with Server local I don't know what exact I have to given in this....please help me regarding this
@KSRDatavizonАй бұрын
Hi Benis! To connect to your local MySQL server after installation, follow these steps: Open MySQL Workbench (or your preferred MySQL client). Create a New Connection: Click on the “+” icon next to "MySQL Connections." In the “Connection Name” field, give it a name (e.g., "Local MySQL"). Connection Method: Choose “Standard (TCP/IP)” as the connection method. Enter Hostname: For a local server, enter localhost or 127.0.0.1. Port Number: The default MySQL port is 3306, so you can leave it as is unless you’ve configured a different one. Username and Password: Enter your MySQL username (usually root by default) and the password you set during installation. Test Connection: Click on the “Test Connection” button to ensure everything is set up correctly. Save and Connect: If the test is successful, click “OK” to save the connection, then double-click the new connection to connect to your local server. If you run into any issues, feel free to ask for more help!
@sameenfatima6992 Жыл бұрын
Does this parameter thing for numeric columns too?
@KSRDatavizonАй бұрын
Yes, parameters can be used for numeric columns in Power BI as well! Here’s how you can leverage parameters for numeric columns: Create a Numeric Parameter: You can create a numeric parameter that allows users to input or select a specific value. This is useful for scenarios like thresholds, filtering, or what-if analysis. Use in Calculations: Once the parameter is created, you can reference it in your measures or calculated columns.
@meraj60036 ай бұрын
when I am applying filter to the imported query, the filter isn't working with that query
@KSRDatavizon2 ай бұрын
Check datasource or filters are part of different table need to model datasets or tables to make sure filters are working
@raginiminivlogger8 ай бұрын
Can you share the file for Practice which you used in vedio
I'm getting error on powerBI while connecting to mysql workbench-"Microsoft sql-a networks related or instance specific error occurred while establishing a connection to SQL server .the server was not found or not accessible and verify that SQL server is configured to allow Remote connections"...this is displayed always...i've watched tons and tons of videos..and still isn't resolved... please help me out..😢
@KSRDatavizonАй бұрын
"Hi @mohammadaffan5001, I understand how frustrating this can be! 😢 The error you're facing usually occurs when Power BI can't connect to the MySQL server due to network or configuration issues. Here are a few steps you can try: Enable Remote Connections: Make sure that MySQL Workbench is set to allow remote connections. Open MySQL Workbench → Navigate to Management → Users and Privileges → Ensure your user is set to allow connections from any host ('%'). Check Firewall Settings: Ensure that the firewall on the server and local machine is not blocking the MySQL port (default is 3306). You can temporarily disable the firewall to see if that resolves the issue. Verify Server IP: Double-check that you're using the correct server IP address and port in Power BI when trying to connect. SQL Server Configuration: If you're connecting via SQL Server, open SQL Server Configuration Manager, and make sure: The SQL Server Browser service is running. TCP/IP is enabled under Protocols for MSSQLSERVER. Connection String: Ensure that the connection string is properly configured with the right credentials, and the database is online and accessible. If none of these work, feel free to share more details (e.g., the exact error message), and I'll try to help further. Hope this helps, and hang in there-you'll get it resolved! 😊"