@RADACAD, Your way of teaching is excellent. This video is really useful to me. Infact, not only this video, all your videos are useful. I'm thankful to you!
This approach work for direct query ? im seeing this error Failed to save modifications to the server. Error returned: 'DirectQuery partition 'DimProduct-f5c7e8b6-9037-4b5e-bc93-9ed1fe9f39fe' has '2' datasource reference(s) in its expression which is not allowed. '.
Hi, i am facing one issue in Power BI Desktop V Nov2021- I need to connect the two different types of files (xlsx and HTML) at the same from the same folder. both types are having the same structure (number of columns and header). The current type is xlsx is connected and now I have to add the HTML type in the same folder. for this, I have created a parameter? as data will continue in both files. appreciate your help in advance.
Question would be how to offer this feature to an end user. He/She is not able to click edit queries and there is no way to link a parameter from the report to the backend powerquery parameter or is there? Highly appreciate your input here!
It is worth pointing out that parameter options are not available for Power BI reports deployed to Power BI Report Server. It will be good to know, how to achieve the same in such cases?
You can use this method with any type of data source. however, changing the parameter value using slicer won't be the best experience, because even if you implement it this way, the user has to REFRESH the PBIX file after the change in the slicer. Power Query parameters aren't meant to be changed through UI. I have a video about the difference of Power Query parameters and Power BI DAX parameters in this channel. worth to watch.
Than you for this nice tutorial, Reza! I am facing a similar situation right now where I need to update the data source from a Power BI Report from Excel to SQL Server. What if I don't want to keep that Excel data source and work only with the SQL Server data source? Can I simply overwrite the M codes in "Fact Internet Sales" with those from "Fact Internet Sales (2) (and thus get away with the need to create a new Parameter)? Would this approach still maintain the existing relationships among the tables?
Hello Genius, I never miss your any of the videos and you are absolutely amazing in this. Well, i have one query if you could guide me here, - Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query. - Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder? - as we know after refracing of query it would load fresh data only in model. basically, i want to preserve old data also in my excel where i have load the query. Thanking you in advance.
@@harshitdoshi2004 DirectQuery and Import data are two different methods of connecting to the data source. You can re-build your model by getting data from the source using DQ, but then copy and paste visuals into the new report
![NLE Choppa - Or What ft. 41 (Orchestra Mix) [Official Music Video]](http://i.ytimg.com/vi/biOFASEgSOM/mqdefault.jpg)
Rezza, this video doesn't deserve 100+ likes. It deserves a million+ or more likes. Thank you for this video
Thanks for your kind words. I am glad it helps!
Thank you Reza, that saved me 20 days of time!
@RADACAD, Your way of teaching is excellent. This video is really useful to me. Infact, not only this video, all your videos are useful. I'm thankful to you!
I am glad we could help, thanks for your kind words :)
Really useful and clear explanation. Thank you
This approach work for direct query ? im seeing this error
Failed to save modifications to the server. Error returned: 'DirectQuery partition 'DimProduct-f5c7e8b6-9037-4b5e-bc93-9ed1fe9f39fe' has '2' datasource reference(s) in its expression which is not allowed. '.
Hi,
i am facing one issue in Power BI Desktop V Nov2021- I need to connect the two different types of files (xlsx and HTML) at the same from the same folder. both types are having the same structure (number of columns and header). The current type is xlsx is connected and now I have to add the HTML type in the same folder. for this, I have created a parameter? as data will continue in both files.
appreciate your help in advance.
Great stuff.
Any thoughts how to stop refreshing if datasource is missing?
Custom Error message or just do not refresh...
Thanks for the tutorial. Where do I get the links you keep mentioning because I don't see them in the description like you stated. Thanks
Can I pass the datasource as a parameter in the URL of the published report?
Thanks this is really helpful and will save a lot of manual rework to rebuild with different data source type
Question would be how to offer this feature to an end user. He/She is not able to click edit queries and there is no way to link a parameter from the report to the backend powerquery parameter or is there?
Highly appreciate your input here!
I tried to connect it with google drive but didn’t work for me , it was showing me error in displaying visuals
Can we use parameters for the data source of snowflake in power bi?
Fabulous video
Thanks @radacad
I have one qn
What if we had to add three or more data source what is the query for that?
Can u pls explain
It is worth pointing out that parameter options are not available for Power BI reports deployed to Power BI Report Server. It will be good to know, how to achieve the same in such cases?
Can we do the same for azure databricks in a similar way?
And I want to change the parameter value using slicer
You can use this method with any type of data source.
however, changing the parameter value using slicer won't be the best experience, because even if you implement it this way, the user has to REFRESH the PBIX file after the change in the slicer.
Power Query parameters aren't meant to be changed through UI. I have a video about the difference of Power Query parameters and Power BI DAX parameters in this channel. worth to watch.
Thanks, two questions
1. Can we just replace excel to DB query so it will point to SQL?
2. Can I do same for Merge query?
Very useful, I did something similar to point to a local folder vs a Sharepoint, great tutorial.
Thanks Pepe. It was great to hear the scenario you used this approach for.
Than you for this nice tutorial, Reza! I am facing a similar situation right now where I need to update the data source from a Power BI Report from Excel to SQL Server. What if I don't want to keep that Excel data source and work only with the SQL Server data source? Can I simply overwrite the M codes in "Fact Internet Sales" with those from "Fact Internet Sales (2) (and thus get away with the need to create a new Parameter)?
Would this approach still maintain the existing relationships among the tables?
Yes this should work. best regards
That is correct. you won't need parameter and IF statments
Hello Genius,
I never miss your any of the videos and you are absolutely amazing in this.
Well, i have one query if you could guide me here,
- Let's say i have load query from folder and i have multiple files available in that folder belongs to every month sales and let's say i have built one report and loaded in excel using power query.
- Now after deleting a few files from folder, how could i keep old file data in excel where i have loaded the query besides that file get removed from folder?
- as we know after refracing of query it would load fresh data only in model.
basically, i want to preserve old data also in my excel where i have load the query.
Thanking you in advance.
This is excellent. Can you also change the connection type from Import to Direct Query?
Unfortunately that won't be possible using parameters. you need to change some specifics of the Power BI file for that.
@@RADACAD Can you elaborate on what specifics do I need to change?
@@harshitdoshi2004 DirectQuery and Import data are two different methods of connecting to the data source. You can re-build your model by getting data from the source using DQ, but then copy and paste visuals into the new report
Keep id data source link to practice
But I mean what's the use why would someone use same structure of report on different sources.