Forum Discussion

HusnaPowerBI's avatar
HusnaPowerBI
New Member
4 months ago
Solved

Urgent help in Power BI Service: Data source credentials missing + Google Sheets CSV not refreshing

I am building a Power BI report in Power BI Desktop using two different data sources: a Google Sheets file accessed through a public CSV export URL, and a website that provides data in JSON format. T...
Data Protection
Dataflow
Interesting Links
Need Help
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    4 months ago

    Hi HusnaPowerBI,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Odet_Maimoni and cengizhanarslan for the prompt response.

     

    Thank you for the response. Clearing cache in power bi desktop is completely safe and will not impact your transformed data, it only clears the local preview cache. Please follow below steps:

    File --> Options and settings --> Options --> Data Load --> Clear cache.

     

    Thanks and regards,

    Anjan Kumar Chippa

     

     

Odet_Maimoni's avatar
Odet_Maimoni
Advocate I
4 months ago

Two quick fixes:

 

1. JSON (works in Desktop, fails in Service)

Service is picky with “Anonymous”.

 

Go to Dataset Settings → Data source credentials  → Set to Public  

If still failing, switch to base URL + RelativePath:

 

Web.Contents(

    "https://api.website.com",

    [RelativePath = "endpoint"]

)

 

2. Google Sheets not updating

This is caching 99% of the time.

 

Make sure you use export URL (not share link):

https://docs.google.com/spreadsheets/d/{ID}/export?format=csv&gid={GID}

 

Add cache breaker:

 

&t=" & DateTime.LocalNow()

 

 

Also verify sheet is published to web and no filters hiding rows

 

Odet Maimoni  

BI Engineer | Microsoft MVP  

I share practical Power BI tips on YouTube

HusnaPowerBI's avatar
HusnaPowerBI
New Member
4 months ago

Thanks for the reply. I tried adding the cache breaker, but unfortunately it didn’t solve the issue. I do understand that it’s likely a caching problem.
Is it possible to clear the cache in Power BI instead and would that have any impact on my transformed data?

  • v-achippa's avatar
    v-achippa
    Community Support
    4 months ago

    Hi HusnaPowerBI,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Odet_Maimoni and cengizhanarslan for the prompt response.

     

    Thank you for the response. Clearing cache in power bi desktop is completely safe and will not impact your transformed data, it only clears the local preview cache. Please follow below steps:

    File --> Options and settings --> Options --> Data Load --> Clear cache.

     

    Thanks and regards,

    Anjan Kumar Chippa

     

     

    • v-achippa's avatar
      v-achippa
      Community Support
      4 months ago

      Hi HusnaPowerBI,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        4 months ago

        Hi @HusnaPowerBI,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa