Видео

nice pro keep going

Which IDE are you using? I really like it.

Im Not getting option as Machine Learning Model after creating dataset

Can you make a video how to push the data from snowflake table to api endpoint

Hello Brother, Videos is excellent and thanks for sharing. But you never show the output of the script ? if you share us the code. That great for the practice also.

Thank you, i did as it is;Now it worked for me

Approach 2 - Outside Snowflake : import pandas as pd import requests as re import sqlalchemy as sa from snowflake.sqlalchemy import URL engine=sa.create_engine( URL( account='xx1234.ap-southeast-1', user='username', password='Password@123!', database='DEMO', schema='DEMOSCHEMA', warehouse='COMPUTE_WH', role='ACCOUNTADMIN' ) ) url = 'example.com/api/data' # Replace with your actual API URL and Headers header = {'Content-Type':'application/json', 'Accept-Encoding':'deflate'} response=re.get(url,headers=header) dt=response.json() df=pd.json_normalize(dt,'data') #pushing data from python dataframe to snowflake df.to_sql('CryptoData',con=engine,index=False,if_exists='append') engine.dispose()

Approach 1 as demonstrated in video: CREATE or replace PROCEDURE fetchApiData() RETURNS STRING LANGUAGE PYTHON RUNTIME_VERSION ='3.8' PACKAGES = ('requests','pandas','snowflake-snowpark-python') HANDLER = 'getData' EXTERNAL_ACCESS_INTEGRATIONS =(my_api_integration) EXECUTE AS OWNER AS $$ import requests as rq import pandas as pd from snowflake.snowpark import Session def getData(SESSION): apiurl='example.com/api/data' # Replace with your actual API URL and Headers header = {'Content-Type':'application/json', 'Accept-Encoding':'deflate'} response = rq.get(apiurl,headers=header) data = response.json() df = pd.DataFrame(data) SESSION.write_pandas(df=df, table_name='DimTable', database= 'DEMO_DATABASE', schema= 'DEMO_SCHEMA',auto_create_table=True, overwrite=True) return 'Data loaded succesfully' $$; --adhoc basis data fetching/loading CALL fetchApiData(); CREATE TASK DAILY_API_PULL_DATA WAREHOUSE = COMPUTE_WH SCHEDULE = 'USING CRON 0 9 * * * UTC' -- Schedule to run at 9:00 AM UTC daily AS CALL fetchApidata(); ALTER TASK DAILY_API_PULL_DATA RESUME;

External Access Integrations : docs.snowflake.com/en/sql-reference/sql/create-external-access-integration

Hi can you make video for current logged user and orther user list ,, does this solution works for that too ?? kindly suggest. thnx

Hi @The BI Hub, Nee to Implement RLS to prevent some users from accessing Drillthrough in powerbi, kindly advise on same

What if an unauthorized user clicks on a shared link to a page that was not available? It will probably be able check the page, as it is not really hidden. I mean, this works but for very sensitive data I'm not sure is safe enough

how can we write the header if we want to fetch pools table from uniswap api

How can we automate data backup and download data from salesforce automatically in the local storage

thanks for that! we need more of these please. ETL and ELT processes.

Copilot and ChatGPT got nothing on you guys. every time I try to fix something in power apps or power BI i am wasting time on AI. It's always an Indian guy on YT who comes to the rescue!

Super helpful

But how do we get to know from which date data ic coming and we need to refresh from which date? I've my source as Oracle and I need to refresh 10 records which are updated and 5 new records which came today. How PBI will rectify that?

Thanks, its very helpful.

to avoid escaping backslashes, use raw strings, like r"C:\path"

Imformative

On point, thanks

Nice information however you forgot to show the viewers how did you join all those tables that you created in the model.

Not getting accurate results. i imported a csv and was trying to refresh the data incrementally. Data policy not understood properly.

very helpful and informative video, keep making such good clips for those who want to know more from basic to pro level..

How to apply incremental refresh in Power BI service?

Theme Generator Link : themegenerator.point-gmbh.com/en/Home

Nice work , can you share the Pbix file , you are not show the relationship or the tables

Very nice. Great info!

What if user input another user email address to see hidden pages?

Why isn't the "forecast" option displayed in the "chose a model" step?

good 👍

Nice

In my home page have navigation to 7 different pages. When set row level security for only access to 2 pages. It showing only in slicer, but i can go to all pages

Suppose my data changes earlier I was having data till 2024 Jun and now I have data till 2023 dec then how it works , currently I am facing problem on this can someone help me

I want rls in report server.. Without publish the report. It is possible to set page level security in report server without the mail id with their gen id.

Useful. Thank you.

Thank you so much! I needed this for work😊

Very much needed in current scenarios.

good one, thank you for sharing

First!! Awesome 💯💯🚀🚀

what if we have thousands of categories?

Thanks

Thank you very much!!!

Hi.. Is it possible to connect via email with you...? ☺

Clean explanation

tq

For all 3 imports, can you please help with the error :: Import 'requests' could not be resolved by Pylance???

how can we use in mysql

Good explanation with easy method 👏