Пікірлер
@noueruz-zaman7894
@noueruz-zaman7894 Ай бұрын
at 4:43 it is strange because you should be able to use direct query with store procedure.
@sadhanasawant7135
@sadhanasawant7135 Ай бұрын
I have around 10 parameters for my visual store procedure, following same process but getting error like this: Expression.Error: We cannot apply operator & to types Text and Table. Details: Operator=&
@PratyushThapa-k7k
@PratyushThapa-k7k 2 ай бұрын
How to change Text .....if hide show .and if show text will be hide
@PS65501
@PS65501 2 ай бұрын
How to pass slicer values to those parameters?
@SaraKhan-cv9sj
@SaraKhan-cv9sj 3 ай бұрын
Very helpful , thank you so much.
@byreshgowda7485
@byreshgowda7485 3 ай бұрын
Great explanation 👏
@mythilysathish7725
@mythilysathish7725 3 ай бұрын
Thanks for Sharing this. I was directed to this video when I needed it for one of my personal projects. Then quoted my experience with this in a job interview. Now using this logic on my job!!
@vathsovanna339
@vathsovanna339 4 ай бұрын
If we want to view two sheets at the same time, what is the code?
@AntrikshSharma
@AntrikshSharma 4 ай бұрын
You can just go to View -> New Window -> View side by side
@KaiAuh-h6s
@KaiAuh-h6s 4 ай бұрын
Hy
@MarcoMagal
@MarcoMagal 4 ай бұрын
Fantastic, I have use Slicers as I do a lot Dasboards with PowerPivot and it works. Thanks for sharing
@rajeshn8533
@rajeshn8533 4 ай бұрын
Whatif the powebi connection needs user authentication alongwith ping id enabled.
@cristiandiaz3551
@cristiandiaz3551 5 ай бұрын
Is it possible to connect SSAS using python in a Linux enviroment?
@vaibhavshrm07
@vaibhavshrm07 5 ай бұрын
nice work done 👍
@fabioplos1534
@fabioplos1534 5 ай бұрын
select * from $SYSTEM.TMSCHEMA_COLUMNS also show the columns
@rocklemon4948
@rocklemon4948 6 ай бұрын
Thank you that was great help
@ZeeshanAli-hd1fz
@ZeeshanAli-hd1fz 6 ай бұрын
connction_string = f'Provider=MSOLAP; Data Source={port_number}; Catlog={model_name};' dax_query = """ Evaluate DimCustomers """ con = Pyadomd(connction_string) con.open() result = con.cursor().execute(dax_query) df = pd.DataFrame(result.fetchone()) print(df) con.close() """NameError Traceback (most recent call last) Cell In[3], line 13 7 connction_string = f'Provider=MSOLAP; Data Source={port_number}; Catlog={model_name};' 9 dax_query = """ 10 Evaluate DimCustomers 11 """ ---> 13 con = Pyadomd(connction_string) 15 con.open() 16 result = con.cursor().execute(dax_query) File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\pyadomd\pyadomd.py:127, in Pyadomd.__init__(self, conn_str) 126 def __init__(self, conn_str:str): --> 127 self.conn = AdomdConnection() 128 self.conn.ConnectionString = conn_str NameError: name 'AdomdConnection' is not defined""" Connecting SSAS to Python
@AntrikshSharma
@AntrikshSharma 6 ай бұрын
catalog's spelling is incorrect
@ZeeshanAli-hd1fz
@ZeeshanAli-hd1fz 6 ай бұрын
​@@AntrikshSharma System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.AnalysisServices.AdomdClient' at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.Assembly.Load(AssemblyName assemblyRef) at Python.Runtime.AssemblyManager.LoadAssembly(AssemblyName name) at Python.Runtime.CLRModule.AddReference(String name) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. This error is raised when Pyadomd is not able to find the AdomdClient.dll file The error might be solved by adding the dll to your path. Make sure that the dll is added, to the path, before you import Pyadomd. If in doubt how to do that, please have a look at Getting Stated in the docs. I do have AdomdClient in my system
@bigbunny4000
@bigbunny4000 5 ай бұрын
@@AntrikshSharma i get the same error, but my spelling is correct!
@satyapalrawat7857
@satyapalrawat7857 6 ай бұрын
HI Antriksh, Thank you for posting this video. It is very helpful. I followed all the instructions and still getting an error and don't know why. Would it be possible for you to please suggest further? below is the error I am getting. NameError Traceback (most recent call last) Cell In[28], line 1 ----> 1 conn = Pyadomd(conn_str) File ~\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pyadomd\pyadomd.py:127, in Pyadomd.__init__(self, conn_str) 126 def __init__(self, conn_str:str): --> 127 self.conn = AdomdConnection() 128 self.conn.ConnectionString = conn_str NameError: name 'AdomdConnection' is not defined
@AntrikshSharma
@AntrikshSharma 6 ай бұрын
I think the issue is with the connection string, which on of these (PBI Desktop, SSAS, or PBI Service) are you working with?
@QinZhang-xd7cu
@QinZhang-xd7cu 7 ай бұрын
This is useful for report developer. How do we let users change parameters? The import mode does not allow to bind parameters then to be used in a slicer or a filter. Or the requestion is how do we call stored procedure in Direct Query mode (this will allow to bind parameters then set up a user facing slicer or filter to update parameters)?
@chandu0341
@chandu0341 8 ай бұрын
@ankit Sharma - if I have a brand url along with rank, could please do a video or suggest the solution? It would be really appreciate for your efforts.
@markandjessicaflynn158
@markandjessicaflynn158 8 ай бұрын
What if you need a second column filter, say in your example you wanted to filter brand and type?
@saifulislam-xq9wh
@saifulislam-xq9wh 8 ай бұрын
bro provide the data source
@holisqueisequehase5054
@holisqueisequehase5054 9 ай бұрын
This is brilliant, thanks. How could I hide/unhide more than one shape at a time? I'm trying: Me.Shapes("Green1", "Green2").visible=msoTrue but it's not working :(
@AntrikshSharma
@AntrikshSharma 8 ай бұрын
For a simple code you can write: Sheet1.Shapes.Range(Array("Rectangle 1", "Rounded Rectangle 2")).Visible = msoFalse You can make it a bit more robust by creating a private sub and passing on just the shapes names in an array: Sub MainSub() Dim ShapesList As Variant ShapesList = Array("Rectangle 1", "Rounded Rectangle 2") Call HideShapes(ShapesList, Sheet1) 'Sheet1 is the codename visible in VBE End Sub Private Sub HideShapes(ShapeList As Variant, TargetWorksheet As Worksheet) Dim ShapeName As Variant Dim IndividualShape As Shape For Each ShapeName In ShapeList For Each IndividualShape In TargetWorksheet.Shapes If IndividualShape.Name = ShapeName Then IndividualShape.Visible = msoFalse End If Next IndividualShape Next ShapeName End Sub
@andrewjones2117
@andrewjones2117 9 ай бұрын
I’m getting an error saying The field ‘column name’ of the record wasn’t found. Made sure names match and line is correct to what you put, substituting Brand for my columns name. Not sure what is wrong here.
@daneshsharrma8855
@daneshsharrma8855 9 ай бұрын
Greatly helped me, God bless you brother.
@cabroncito29
@cabroncito29 9 ай бұрын
This is awesome! Excellent video. Question for you: is it possible to use a formula for the EndDateParam value? For example, to always have it be today's date?
@philipposorfanos209
@philipposorfanos209 10 ай бұрын
What happens in the case of a leap year like 2008 where February 29 is included?
@MichaelGiusto
@MichaelGiusto 10 ай бұрын
OK, now let's see you add slicers so a user can set the parameters then click "Apply All Slicers" and have your stored proc run and return the data.
@ankithmg2331
@ankithmg2331 10 ай бұрын
Hi, To use pyadomd, do we need dll file to be downloaded?
@yxyxycc
@yxyxycc 10 ай бұрын
Super! Thanks👍
@Akshayjaunjalkar
@Akshayjaunjalkar 10 ай бұрын
Circular dependency
@mariocanizalez
@mariocanizalez 10 ай бұрын
Hello Antriksh Sharma, can I use this Path library in a Fast Api project in a Docker container, that is, be able to copy the folder so that it works in a Docker File image on Linux?
@AntrikshSharma
@AntrikshSharma 10 ай бұрын
I have no knowledge of Docker/Linux, I now recommend using REST APIs for executing DAX Queries.
@mariocanizalez
@mariocanizalez 10 ай бұрын
@@AntrikshSharma , Could I use Python's Fastapi? If so, how can I add the library in the production environment in Windows OS and Linux OS?
@cristiandiaz3551
@cristiandiaz3551 5 ай бұрын
@@AntrikshSharma It didn't work if the dataset its on SSAS
@bigpicture8309
@bigpicture8309 10 ай бұрын
well done, very creative. Is it possible to share the workbook?
@Hardivh
@Hardivh 10 ай бұрын
I need to do something like this but using the parameters on the Report part, not on the power query part, like a prompt the end user selects
@Alex_Xela2
@Alex_Xela2 7 ай бұрын
hi,i m loking for same.
@emili84848
@emili84848 10 ай бұрын
Very good explanation Antriksh! You are a master of PQ, Thank you!
@kartheekpatnaik8644
@kartheekpatnaik8644 11 ай бұрын
Nice one
@pthapa55
@pthapa55 11 ай бұрын
Is it possible for the user to select from the dropdown on the report visual to change the parameter values for Start date and end date? For example I want my user to be able to filter down and select the date range for Start date and end date on the visual, so based on those selection, report needs to be updated. How can I do it if possible?
@sireeshatammineni3851
@sireeshatammineni3851 11 ай бұрын
Hi, is it work for column in a table
@shwetkumar1719
@shwetkumar1719 11 ай бұрын
Can we sort it Age group if it is column?
@priyal_001
@priyal_001 11 ай бұрын
What if I have both month and date
@500iq6foot8
@500iq6foot8 11 ай бұрын
Cant you just made the new field negative the date?
@redhaakhund1271
@redhaakhund1271 Жыл бұрын
👍👍👍👍👍
@ryzen7109
@ryzen7109 Жыл бұрын
Thanks 🎉🎉🎉
@abtokarev
@abtokarev Жыл бұрын
Year Sort = DATEDIFF( 'Dates'[Date], MAX( 'Dates'[Date] ), YEAR ). No need to save result of calculation stages in variables. No need to add 1 to result. There is no error when sorting Calendar Year by this new column.
@sudipchakraborty9283
@sudipchakraborty9283 Жыл бұрын
Getting error message: Expression.Error: A cyclic reference was encountered during evaluation.
@tiffanybarnes2000
@tiffanybarnes2000 Жыл бұрын
B3!!! Antriksh, Thank you for the knowledge!
@laviecest5811
@laviecest5811 Жыл бұрын
This is very helpful. Thanks so much
@mehmetatas5459
@mehmetatas5459 Жыл бұрын
hello ()=> and each perform the same task. If we use each instead of (InnerBrand) => InnerBrand[Brand] = CurrendBrand[Brand] without creating a function, what kind of function should we use? That is, not Table.SelectRows(Source, (InnerBrand)=> InnerBrand[Brand] = CurrendBrand[Brand] Table.SelectRows(Source, each ???? I would be happy if you help
@AntrikshSharma
@AntrikshSharma Жыл бұрын
I don't rely on each at all unless the code is auto generated and does only 1 thing in the iteration, if I have to refer to 2 columns of the same name from different context then it is better to create and label your own function, this helps in readability. Is there any specific reason why you want to use each?
@dwada2459
@dwada2459 Жыл бұрын
Your code for dynamically concatenating columns has solved an issue I was struggling with for quite some time. Thank you. I was extracting boxed comments from PDF, which resulted in zero to up to probably 10 columns, depending on row. I wanted to concatenate those columns into one in each row. The code you provided in the advanced editor worked just great!
@herrdaveed
@herrdaveed Жыл бұрын
Thank you, this covered exactly what I was looking for
@rebagaines8331
@rebagaines8331 Жыл бұрын
This was exactly what I needed