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

     

     

cengizhanarslan's avatar
cengizhanarslan
Super User
4 months ago

Step 1) Go to your workspace in Power BI Service → find your semantic model → Settings

Step 2) Data source credentials → click Edit credentials next to each source → set Authentication method to Anonymous → Privacy level to None (or Public) → Save