at 4:43 it is strange because you should be able to use direct query with store procedure.
@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-k7k2 ай бұрын
How to change Text .....if hide show .and if show text will be hide
@PS655012 ай бұрын
How to pass slicer values to those parameters?
@SaraKhan-cv9sj3 ай бұрын
Very helpful , thank you so much.
@byreshgowda74853 ай бұрын
Great explanation 👏
@mythilysathish77253 ай бұрын
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!!
@vathsovanna3394 ай бұрын
If we want to view two sheets at the same time, what is the code?
@AntrikshSharma4 ай бұрын
You can just go to View -> New Window -> View side by side
@KaiAuh-h6s4 ай бұрын
Hy
@MarcoMagal4 ай бұрын
Fantastic, I have use Slicers as I do a lot Dasboards with PowerPivot and it works. Thanks for sharing
@rajeshn85334 ай бұрын
Whatif the powebi connection needs user authentication alongwith ping id enabled.
@cristiandiaz35515 ай бұрын
Is it possible to connect SSAS using python in a Linux enviroment?
@vaibhavshrm075 ай бұрын
nice work done 👍
@fabioplos15345 ай бұрын
select * from $SYSTEM.TMSCHEMA_COLUMNS also show the columns
@rocklemon49486 ай бұрын
Thank you that was great help
@ZeeshanAli-hd1fz6 ай бұрын
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
@AntrikshSharma6 ай бұрын
catalog's spelling is incorrect
@ZeeshanAli-hd1fz6 ай бұрын
@@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
@bigbunny40005 ай бұрын
@@AntrikshSharma i get the same error, but my spelling is correct!
@satyapalrawat78576 ай бұрын
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
@AntrikshSharma6 ай бұрын
I think the issue is with the connection string, which on of these (PBI Desktop, SSAS, or PBI Service) are you working with?
@QinZhang-xd7cu7 ай бұрын
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)?
@chandu03418 ай бұрын
@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.
@markandjessicaflynn1588 ай бұрын
What if you need a second column filter, say in your example you wanted to filter brand and type?
@saifulislam-xq9wh8 ай бұрын
bro provide the data source
@holisqueisequehase50549 ай бұрын
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 :(
@AntrikshSharma8 ай бұрын
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
@andrewjones21179 ай бұрын
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.
@daneshsharrma88559 ай бұрын
Greatly helped me, God bless you brother.
@cabroncito299 ай бұрын
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?
@philipposorfanos20910 ай бұрын
What happens in the case of a leap year like 2008 where February 29 is included?
@MichaelGiusto10 ай бұрын
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.
@ankithmg233110 ай бұрын
Hi, To use pyadomd, do we need dll file to be downloaded?
@yxyxycc10 ай бұрын
Super! Thanks👍
@Akshayjaunjalkar10 ай бұрын
Circular dependency
@mariocanizalez10 ай бұрын
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?
@AntrikshSharma10 ай бұрын
I have no knowledge of Docker/Linux, I now recommend using REST APIs for executing DAX Queries.
@mariocanizalez10 ай бұрын
@@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?
@cristiandiaz35515 ай бұрын
@@AntrikshSharma It didn't work if the dataset its on SSAS
@bigpicture830910 ай бұрын
well done, very creative. Is it possible to share the workbook?
@Hardivh10 ай бұрын
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_Xela27 ай бұрын
hi,i m loking for same.
@emili8484810 ай бұрын
Very good explanation Antriksh! You are a master of PQ, Thank you!
@kartheekpatnaik864411 ай бұрын
Nice one
@pthapa5511 ай бұрын
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?
@sireeshatammineni385111 ай бұрын
Hi, is it work for column in a table
@shwetkumar171911 ай бұрын
Can we sort it Age group if it is column?
@priyal_00111 ай бұрын
What if I have both month and date
@500iq6foot811 ай бұрын
Cant you just made the new field negative the date?
@redhaakhund1271 Жыл бұрын
👍👍👍👍👍
@ryzen7109 Жыл бұрын
Thanks 🎉🎉🎉
@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 Жыл бұрын
Getting error message: Expression.Error: A cyclic reference was encountered during evaluation.
@tiffanybarnes2000 Жыл бұрын
B3!!! Antriksh, Thank you for the knowledge!
@laviecest5811 Жыл бұрын
This is very helpful. Thanks so much
@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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
Thank you, this covered exactly what I was looking for