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
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.
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!
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)
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
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!
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.
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..😢
"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! 😊"
![How to Download and Install MySQL [2023] | Step by Step Guide | MySQL | KSR Datavizon |](http://i.ytimg.com/vi/NwVzkqQNZwc/mqdefault.jpg)
![How to Download and Install MySQL [2023] | Step by Step Guide | MySQL | KSR Datavizon |](/img/tr.png)
![How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]](http://i.ytimg.com/vi/WgE8pVLgWGs/mqdefault.jpg)
Loud and Clear!! Thank you for this informative video!!
Very nice 🎉
Thank You
Very helpful thank you si much... Kindly do few more real time projects
Sure 👍
You're amazing, clear & precise. Thank you for your valuable efforts and time.
You are so welcome, Please susbcribe our channel for regular updates.
Nice and clear explanation ..Thank you so much 🎉
You are welcome 😊
Thanks giving
Informative.thank u..
Thank you very much. I benefited a lot from the video
Glad it was helpful!, Please subscribe our channel for regular updates
Quite a useful session, thank you
Great tutorial short and to the point!
Glad it was helpful! Thank you, Please subscribe our channel for regular updates, its motivate us
Useful session ! Very easy to understand and clear voice.
thank you so much
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
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.
❤ love this video
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.
do another vdo for sql server and how to work with dax when connected with direct query
sure, will plan shortly
If we publish the dashboard and do a schedule refresh is it gonna updated automatically or we need to run the sql report first?
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!
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)
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
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!
Does this parameter thing for numeric columns too?
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.
can you share any power bi resume for 5+ relevant experience
www.datavizon.com/s/pages/resume
@@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
when I am applying filter to the imported query, the filter isn't working with that query
Check datasource or filters are part of different table need to model datasets or tables to make sure filters are working
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..😢
"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! 😊"
Can you share the file for Practice which you used in vedio
drive.google.com/drive/folders/1_MrrzHizjFRSeiXVwzbb4SCQf4lfAQqa?usp=sharing
Can u plz share the dataset and SQL script
drive.google.com/drive/folders/1W3alj8Q2nD1V9huvurFceV4TNVu4HLlc